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
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.