SQL Server Integration Services (SSIS) is great at importing or exporting files with known format and number of columns. But what happens when the client leaves out a delimiter, or adds an extra delimiter, or when a format is specified that can’t be read or written using the standard methods available? That’s when the power of Scripting and the Script Component in the Data Flow Task becomes a useful if not essential tool. In this presentation, I will provide C# and VB code I have used in order to solve the following Import/Export cases, extra or insufficient column delimiters, multiple layouts embedded in the same file, and cleanup of special characters and correcting data.
2021 Summit video library