O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Script Component as a Destination

Writing data at non-ordinal destinations and in special formats creates a need for some custom destinations in the Data Flow. The Script Component as Destination will help SSIS Developers get rid of such problems.

In this recipe, we read some data rows from a database query and load them into a text file destination in a specific format as shown here:

NationalIDNumber
FirstName|LastName|Gender|MaritalStatus
JobTitle;HireDate;DepartmentName;DepartmentGroupName;StartDate;EndDate

The first data row should have NationalIDNumber, the second data row should have personal information that's delimited by a vertical line ( | ), and finally the third row has professional information delimited by a semi colon ( ; ). Each ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required