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 |
|
preeti_gupta
Starting Member
4 Posts |
 Posted - 2009-07-14 : 02:39:09
|
HiI am using a batch file to execute the SSIS pkg.Following is the script written in the batch file:dtexec /FILE "PATH" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EW >> PATHI get the following error when i open this batch file in the edit mode" The filename, Directory name, or Volume label syntax is incorrect".Also when i run the batch file it gives no error but neither it runs the pkg.Can anyone suggest we the possible reason for the occurance of this error. I have tried several things like renaming file etc but all in vain. RegardsPreetiThanks & regardsPreeti |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-14 : 10:38:15
|
| make sure that "PATH" is a valid path. Use unc name if dtsx is not on local server (not mapped drives). Make sure account running batch file has permission on share where dtsx lives |
 |
|
|
|
|
|
Exec SSIS pkg through a batch file