Custom SSIS Dataflow Script Components for Complex Import, Transform, and Export

Luther Atkinson

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.