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

Managing SQL Role

Recently, we had a scenario, where we need a simple SQL Role which gets read access to bunch of views.  While it was easy to create the vie...