How to Execute

• MalaSuerte

  Old Hand

  Points: 319

  More actions

  March 8, 2007 at 3:23 pm

  #172632

  I have a job that requires me to call and execute a SSIS package as the first step in a SQL2k5 Stored Procedure.

  Can someone please give me a basic template or example or where I could find out how to do this?

  Thanks in advance !

• Anders Pedersen

  SSChampion

  Points: 11410

  More actions

  March 8, 2007 at 3:37 pm

  #693953

  Look into DTEXEC.

• MalaSuerte

  Old Hand

  Points: 319

  More actions

  March 8, 2007 at 3:47 pm

  #693956

  Thanks.

  Anyone have a brief example of the syntax?

• James Moore (Red Gate)

  SSCrazy

  Points: 2644

  More actions

  March 8, 2007 at 4:01 pm

  #693959

  Have a look at:

  http://msdn2.microsoft.com/en-us/library/ms162810.aspx

  - James

  --
  James Moore
  Red Gate Software Ltd

• MalaSuerte

  Old Hand

  Points: 319

  More actions

  March 8, 2007 at 4:08 pm

  #693961

  That's just what I was looking for - perfect !

  Thanks.