Old ladyHow Big Is Your Package?
Size up and convert your DTS package to SSIS. If you have the biggest DTS package, win a gift card and certificate of a world record package size.  
Launch Remote SSIS Package Programmatically - Mike Davis
in

Pragmatic Works

Mike Davis

Launch Remote SSIS Package Programmatically

It can be a pain to launch an SSIS package remotely. So I developed a vb.net standalone application to remotely launch a package. It does require the host computer to have SSIS installed. This is just a beginning program. I am going to be adding other features like variables and config files. Eventually it will allow you to run the package remotely where the package will run on the remote machine. But this will probably require creating a web service.  

Please leave comments, this is my first blog and my first program I have posted online.

 

Thanks

Mike Davis

The source code is attached

Comments

 

KenJ said:

Had some trouble adding a reference for the DTS.Runtime.

Another option to consider might be psExec by sysinternals [1]

psexec \\targetComputer -c dtexec.exe <package>

With this you wouldn't have to have SSIS on your local machine, and the whole process would execute on the remote host.

[1] technet.microsoft.com/.../bb897553.aspx

August 27, 2008 11:26 AM

About Mike Davis

Mike Davis, is a developer, consultant, trainer, and mentor who is enthusiastic about developing robust application for SQL server. He has expertise in many areas of Business Intelligence including Integration Services, Reporting Services, Database Administration, and .Net Software Development. Mike has created BI and software solutions for financial institutions and pragmatic works. He has developed .Net applications for SQL add-ons as well as standalone applications. Mike also participates as a speaker at events like SQL Server 2008 launch and SQL server user group meetings .
Copyright Pragmatic Works
Powered by Community Server (Non-Commercial Edition), by Telligent Systems