Executing DTS using T-SQL.......

• Carl Farmer

  SSCrazy

  Points: 2197

  More actions

  January 24, 2003 at 7:43 am

  #105989

  ...can it be done? If so, how please?

  Thanks in advance.

• Andy Jones, DBA

  Hall of Fame

  Points: 3641

  More actions

  January 24, 2003 at 8:05 am

  #447140

  One option is to use the dtsrun command line utility along with the extended stored prcedure xp_cmdshell. Another option is oulined in the article: -

  http://www.sqlservercentral.com/columnists/jwiner/dts.asp

  Regards,

  Andy Jones

  .

• philcart

  SSC-Forever

  Points: 47796

  More actions

  January 28, 2003 at 2:52 pm

  #447411

  You can also execute the package using the sp_OA stored procedures as shown in the following article.

  http://www.databasejournal.com/features/mssql/article.php/1459181

  Thanks

  Phill Carter

  --------------------
  Colt 45 - the original point and click interface