It is possible for a field in a character-delimited text file to contain a list of further-delimited values instead of the customary single value. This article demonstrates how to load such a file into a staging table, then use a CROSS APPLY query to parse the list of values into a related table.
2019-06-07 (first published: 2017-10-30)
Learn how you can execute multiple scripts in a restrictive database environment that doesn't allow any third-party tools.
2019-07-04 (first published: 2017-08-31)
This article provides step by step instructions to deploy individual SSIS packages in a project deployment model.
2020-02-07 (first published: 2017-08-29)