Archives: September 2009
The SSIS Package Store is a nice option available for storing SSIS packages. The Package Store lists packages stored on the server in the MSDB folder and all packages stored on the file system as long as they are in the default folder (C:\Program Files\Microsoft SQL Server\100\DTS\Packages for SQL 2008)… Read more
I recently worked on a project that involved loading a Data Warehouse from a DB2 source. In this project we used the Microsoft OLE DB Provider for DB2 Data Provider for the ETL process in SSIS.
Unfortunately, one of the limitations to using this Data Provider is the the OLE… Read more