Monthly Archives: June 2009

Creating & Using a Package Template (SQL Server Integration Services)

When we create an Integration Services solution, a package (package.dtsx) gets added to the solution automatically. This package uses the default package template, which is empty with no control flow task. Also when we add a new package (SSIS Packages … Continue reading

Posted in SQL Server, SSIS | Leave a comment

Dynamic columns mapping – Script Component as Destination (SSIS)

Requirement: In Data Flow task of SSIS, we have to define a Data Source as well as a destination to extract & load the data respectively. And as per the functionality of data flow task (DFT), metadata of the source … Continue reading

Posted in SQL Server, SSIS | 183 Comments