Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sauce1979
Starting Member
47 Posts |
 Posted - 2010-04-10 : 17:46:54
|
| 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)DODTSRun /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 |
|
|
|
|
|
DTS BATCH FILE ISSUE