Creating packages in code – OLE-DB Source to Flat File File Destination

This code sample programmatically creates a package with an OLE-DB Source and a Flat File Destination, and the resulting package exports data from SQL Server to a CSV file. The finished package just has the one Data Flow Task shown below.   The code creates the package, configures the task, and components, then saves the… Continue reading Creating packages in code – OLE-DB Source to Flat File File Destination

Creating packages in code – OLE-DB Source to Raw File Destination

This code sample programmatically creates a package with an OLE-DB Source and a Raw File Destination, and the resulting package exports data from SQL Server to a raw file. The finished package just has the one Data Flow Task shown below.   The code creates the package, configures the task, and components, then saves the… Continue reading Creating packages in code – OLE-DB Source to Raw File Destination

CreationName for SSIS 2005 and adding components programmatically

If you are building SSIS 2005 packages programmatically and adding data flow components, you will probably need to know the creation name of the component to add. I can never find a handy reference when I need one, hence this rather mundane post. See also CreationName for SSS 2008. We start with a very simple… Continue reading CreationName for SSIS 2005 and adding components programmatically