Batch file to run DTS package

• eseosaoregie

  SSCertifiable

  Points: 6889

  More actions

  April 10, 2010 at 3:44 pm

  #74058

  I am currently trying to create a batch file which by looping through a list of files imports them into sql via a dts package using DTSRun Utility. I initially tested the batch by importing DTSRun utility in the batch file and it ran with no problems.

  I then added for loop functionality into the batch file to help loop through the list of files and this is where I run into trouble.The syntax is as follows:

  for /f "tokens=1,2,3" %%i in (C:\MyImport\Dirlist.txt)

  DO

  DTSRun /S "(local)" /N "MultipleFileImport" /G "{81FE4AE5-D2CC-47E6-B78C-9309CF4DDFB9}" /L "C:\Documents and Settings\eseosa\My Documents\dtslog.txt" /A "DatabaseName":"8"="ESSBASETESTDW" /A "FileName":"8"="C:\Documents and Settings\eseosa\My Documents\SQL_PRACTICE\%%i" /A "ServerName":"8"="(local)" /W "0" /E

  The batch file now does not run. Any ideas on where I may be going wrong

• eseosaoregie

  SSCertifiable

  Points: 6889

  More actions

  April 14, 2010 at 3:55 am

  #1151194

  I managed to solve this myself. The DO command had to be on the same line as the for /f "tokens = 1,2,3".....

  Regards

  Sauce1979

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  April 14, 2010 at 8:26 am

  #1151393

  Funny, I was actually thinking of using SSIS and a For Each Loop to do this..

  CEWII