How to run a ssis package using a sql statement?
i’m using Sql Server 2008. There are options to run from command line. Is there a way to execute an ssis package using sql statement?
One Solution collect form web for “How to run a ssis package using a sql statement?”
Im my experience one of the easiest way to control them from within SQL is not to try an xp_cmdshell etc but to add a job that executes the SSIS package as the first step and then from within the SQL msdb.dbo.sp_start_job ‘yourjobname’
This also makes it easy to control which account (via proxy / credential) the job gets run under.