PASS logo

Summit video library

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.

Get the latest

Sign up to stay up to date with news, special announcements and educational content.

Redgate will only contact you about PASS Data Community Summit unless you separately request emails about Redgate.