Skip to content

DataType Conversion Utility for Biml

Catherine Wilhelmsen provided the basis for this quick utility. She explains the translation between SSIS, SQL Server and Biml data types. I simply wrapped that data into a script we could reference in our scripts.

See the code here.

Since we have a problem with Biml generating packages with Datetime2 data types, we convert datetime2 -> datetime to get around the issue.