SQL Server Integration Services an Introduction - Part 4

Thursday Jan 22nd 2009 by DatabaseJournal.com Staff

This article is the final article in the 4 part series that introduces SQL Server Integration Services (SSIS). This article shows how to use the SSIS API object model.

[From SQL Server Performance]

Now let’s run through an example of using SSIS API. In this example you will write code using SSIS API to create package, add a task to it, save it on the file system (Same what was created in scenario 1 example of SSIS Designer section above). And later on you will load that package from the file system and execute it, everything programmatically this time.

The article continues at http://www.sql-server-performance.com/articles/biz/SSIS_Introduction_Part4_p1.aspx

Mobile Site | Full Site