Home Forums Article Discussions Article Discussions by Author Discuss content posted by fediori T-SQL insert using SSIS Data Pump RE: T-SQL insert using SSIS Data Pump

  • February 6, 2013 at 4:20 pm

    #1585159

    Federico Iori (2/5/2013)

    How could I launch from T-SQL a SSIS package ? The only way I know is using xp_cmdshell.. purpose of the article was a T-SQL stored procedure able to launch a SSIS package, and this requires xp_cmdshell

    We use SQL Agent to launch and manage our SSIS packages, it's pretty trivial and easy to implement (and you could easily make it dynamic and adapt into your system).