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 |
|
jimcrisp
Starting Member
1 Post |
 Posted - 2008-07-23 : 14:46:01
|
| I have created a DTS job to download a file from and FTP site using the Execute Process Task. It works fine for the day I created it but the next day I have to open it in design view and re-enter the path to the .cmd file. The .cmd file is located on the SQL server. Can anyone tell me how to set this up so I do not have to redo the path each day. This makes kind of hard to schedule the job to run.Thanks, |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2008-07-23 : 17:48:53
|
| The path should be saved when you save your package. There could be another step (such as a Dynamic Properties task) that might be changing the path.Are you scheduling the package from your server? If so, bear in mind that the .cmd file needs to be visible from the server too. If you're running the package locally (ie from your PC) then this doesn't apply.HTH,Tim |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-23 : 22:33:11
|
| For this one, I'll just run the cmd in sql job. |
|
|
|
|
|
|
DTS and Execute Process Task