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 |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2010-06-02 : 06:36:47
|
| I'm new to SSIS and have the following problem:I have an SSIS package which has an Execute Process Task in it.This process has it's executable set to run a bat file whose contents are :-FTP -s:MyFiles.txtThe contents of the MyFiles.txt file hold all the FTP commands:-open myserverusernamepasswordASCIICD mydirectory:GET file1.csvGET file2.csvbyeI am firing this from the server itself, if I run the batfile by double clicking it the files transfer OK,but if i try and run the package from within Visual Studio the process goes green (as if all is OK) but nothing gets transferred?I have set the path within the Execute Process Task as D:\MyDirectory\ (which is where the batfiles reside, and that is where the files get copied when I fire up the batfile by double clicking it).This is the first time I've tried to run a bat file wiht SQL Server 2008, they run OK within 2005 on the old server so I'm a little stumped on this one.Any ideas please. |
|
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
Posted - 2010-06-02 : 09:58:01
|
| Sorted now, it was the 'working directory' part of the process that was causing the problem. |
 |
|
|
|
|
|
FTP not working?