Execution of SSIS Package

[mrx3cas]

Hi,
I Just want to know is is possible to execute a ssis package from vb.net application?If so how to do that???

Please help me if anybody knows about this.
Thanks in advance.

[jmcilhinney]

I've recently deployed an application that executes a stored procedure in the database and that executes the package via xp_cmdshell. The obvious alternative would be SMO.

http://social.msdn.microsoft.com/Sea...20package&ac=3

[mrx3cas]

Hi,
can you tell me what you mean by smo???
Can you give me the syntax for execution of a package via xp_cmdshell???
Thanks for your reply.

[jmcilhinney]

http://social.msdn.microsoft.com/Sea...query=smo&ac=8

xp_cmdshell is an extended stored procedure in SQL server that you can use to execute applications. It is disabled by default for security reasons, so don't enable it lightly. Basically, you simply pass xp_cmdshell the same commandline that you would type into a console window to execute an application. In this case, the application you want to execute is DTEXEC, which is used to execute SSIS packages. That also makes me think that you could just call Process.Start to run DTEXEC too, assuming it's a Windows app. Consult MSDN for the options available when running DTEXEC, because the actual commandline will depend on your specific circumstances.