Programmatically add and connect Data Flow components in SSIS in C#

Question

Is there a high quality sample code for Data Flow Components in SSIS?

I specifically need the following:

OLE DB Source
Derive Column Transformation
Flat File Destination.

Lets say that the table schema comprises of two columns, ID of varchar(2) and Description of varchar(20). The output is a flat file ID of 1 char (just get the first character of ID), and Description of 10 chars (just get the first 10 characters of Description). It would be great if it were in C#.

Lets assume that I know pretty well to add and connect Control Flow Tasks and Connection Managers.

Thanks in advance for your expertise.

EDIT:

We only have SQL Server 2005, so examples in this version would be a great help. But it would really be nice to have 2008 to use ezAPI.

Michael Entin · Accepted Answer · 2009-06-15 17:03:58Z

3

There are samples that do this using "raw" SSIS API, but it is probably easier to use EzAPI for this.

Matt's post on SSIS blog contains a sample that creates a very similar package, it should be trivial to replace Sort with Derived Column: http://blogs.msdn.com/mattm/archive/2008/12/30/ezapi-alternative-package-creation-api.aspx

answered Jun 15, 2009 at 17:03

Michael Entin

7,8223 gold badges25 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Programmatically add and connect Data Flow components in SSIS in C#

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related