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.

at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

AI Tools

https://app.mindpal.space https://riverside.fm Gammas - Gamma https://fathom.video 

  • SSIS Script Component
    In SQL Server Integration services, we have Script Component, which can be used in Data Flow Task as Source, Destination or Transformation. ...
  • C# Virtual & Abstract Properties
    Recently a new learner of C# asked me a question on C# Virtual & Abstract properties.  It turned out to a deep dive.  Detail follows. D...
  • Windows Restart
    I was trying to install SharePoint 2013, the setup was complaining about a pending system restart.  Even after multiple restart / Shutdown. ...