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
Month: January 2009
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