execute ssis with xp_cmdshell

• elham_azizi_62

  SSCertifiable

  Points: 5095

  More actions

  November 6, 2011 at 6:31 am

  #262331

  hello all.

  I use import/export wizard for export query result to an existing dbf file and save this with ssis as filesystem.then i execute this ssis with comand prompt :

  C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn>DTEXEC.EXE /F "C:\DbfExport.dtsx"

  and ssis execute correctly.now i want to execute this ssis with xp_cmpshell in sql server 2008 64bit that running on windows server 2008,i dont know syntax for this.please help me ana give me correcr script for this ,that execute ssis correctly in sql server 2008 64bit,thanks.

• sql_dba123

  SSC Eights!

  Points: 853

  More actions

  November 6, 2011 at 4:01 pm

  #1403747

  Please try this:

  C:\Program Files\Microsoft SQL Server\100\DTS\Binn>DTEXEC.EXE /F "C:\DbfExport.dtsx"

  Reference:

  http://msdn.microsoft.com/en-us/library/ms141766.aspx

• Koen Verbeeck

  SSC Guru

  Points: 259085

  More actions

  November 6, 2011 at 11:40 pm

  #1403787

  The entire SQL statement:

  EXEC xp_cmdshell 'C:\Program Files\Microsoft SQL Server\100\DTS\Binn>DTEXEC.EXE /F "C:\DbfExport.dtsx"'

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP