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.
Sign up to get the latest conference information, announcements and price bump reminders direct to your inbox.
Redgate will only contact you about PASS Data Community Summit and SQL Saturday, unless you separately request emails about Redgate.