none
how to create batch file using the below script and run that batch file using ssis everyday?

    Question

  • Hi All,

    I have below script in which the PDF files will be merged into one single file.Now my req is I have to create batch file for that and run that batch file on daily basis using SSIS.The script is as follows:

    \dev\jobs\prod\INPUT\Sample1.pdf  \dev\jobs\prod\INPUT\Sample2.pdf  cat output \dev\jobs\prod\INPUT\Sample.

    Can anyone guide me how to perform this task.

    Regards,


    sudha

    Saturday, June 29, 2013 6:10 AM

Answers

  • If you can run the above script in a Command Line Window, I would suggest to copy the script code in a text file and save it as batch file (.bat) and run that bat file using a window scheduler job or throuh SSIS. This link will help you how to setup a batch file to run using Execute Process Task in SSIS.

    Vikash Kumar Singh || www.singhvikash.in

    Monday, July 01, 2013 1:34 PM

All replies