Monday, March 12, 2012

Execute SSIS Package from ASP.net 2 Application?

Hello, is it posssible to execute SSIS packages from ASP.NET ? Which code should I Use?

Yes it is. There is an API available to let you do this. I have never used it myself but I know its there.

Loading and Running a Local Package Programmatically
http://msdn2.microsoft.com/en-us/library/ms136090.aspx

-Jamie

|||

Hi Luis,

There's an example of this in the Professional SQL Server 2005 Integration Services book - chapter 17.

You can grab the sample code from the Wrox site.

Hope this helps,
Andy

|||How can I set programatically connection strings for the connection managers?

No comments:

Post a Comment