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

  • Invoke-Sqlcmd unable to create a connection
  • multipe group by, count and join
  • How to retrieve images from SQL Server database into WPF form?? (LINQ, Databinding, SQL)
  • Is it okay to use table look up functionalities in scalar function?
  • Is there a severe performance hit for using Foreign Keys in SQL Server?
  • Help with sql query
  • 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.

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.