running exe application from EXECUTE SQL TASK

• deepa12388

  Grasshopper

  Points: 10

  More actions

  June 13, 2008 at 5:33 pm

  #125822

  I have to run bunch of .src file to txt.file thru executable program which was written in SSIS.

  I have never used execute process task before please help me to run this.

  For multiple files what variable name should be given?

  Lets say name of program is : Data.exe which is in folder C:\Data\

  This .exe takes two input. one input file name and one output file name

  all the source files are located at C:\source\

  Please help me to run this multiple file at once .

  Thanks

• pduplessis-723389

  SSChampion

  Points: 10599

  More actions

  June 16, 2008 at 3:54 am

  #829101

  Hey, readup on xp_cmdshell in BOL.

  But a little footnote on this one, certain environments (like my own) do not allow xp_cmdshell to run.

  ~PD