Friday, August 20, 2010

SSIS Automation

SSIS Provides rich set of API to dynamically create DTSX Packages.

http://blogs.msdn.com/b/mattm/archive/2009/03/02/api-sample-programmatically-create-and-export-configuration-files-for-your-packages.aspx

Codeplex has lot of samples for API reference.  You can download MSI, which covers range of samples.

Will publish my samples and guidelines in my live blog soon.

No comments:

Post a Comment

TSql Script out data

In SQL Server Management Studio (SSMS) you can generate script out the DB Object, you can also generate script for data (Insert statements...