CODEWITHSUNDEEP
sql-serversql-server-2008ssis
Vivek Chandraprakash
Vivek Chandraprakash

Reputation: 1163

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?

-Vivek

Upvotes: 1

Views: 2796

Answers (1)

Andrew
Andrew

Reputation: 27314

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.

Upvotes: 3

Related Questions