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

  • How to Calculate Aggregated Product Function in SQL Server
  • Storing images in database results in partial image
  • I need to pass column names using variable in select statement in Store Procedure but i cannot use dynamic query
  • Returning SCOPE_IDENTITY() using Adodb.Command
  • SQLAlchemy order by function result
  • Full Text Catalog is destroyed after changes in table
  • 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.