Alaska Cowboy
asked on
Can't copy file from one location to another in SSIS
I'm trying to do a simple task, copy the output file to an archive folder, but getting an error: "The connection "E:\FTP\SBI\Archive\Test_l oad_file_2 _output.tx t" is not found."
-------------
a. My connection is called "Archive Conn", which points to E:\FTP\SBI\Archive\Test_lo ad_file_2_ output.txt
so why does it say "The connection "E:\FTP\SBI\Archive\Test_l oad_file_2 _output.tx t" is not found." ???
- there's no CONNECTION called "E:\FTP\SBI\Archive\Test_l oad_file_2 _output.tx t"
--------------
b. it seems as if I have to place the file here: "E:\FTP\SBI\Archive\Test_l oad_file_2 _output.tx t" in order to make this work (but it's not working), BUT . . . the file isn't SUPPOSED to be there, I'm trying to COPY it there, so it wouldn't be there . . .
----------------
I do have another package where I copy a file to an archive location, but I'm building the files with variables, etc. I just thought I'd create a simple package for another task and just not quite grasping how SSIS is thinking . . .
-------------
a. My connection is called "Archive Conn", which points to E:\FTP\SBI\Archive\Test_lo
so why does it say "The connection "E:\FTP\SBI\Archive\Test_l
- there's no CONNECTION called "E:\FTP\SBI\Archive\Test_l
--------------
b. it seems as if I have to place the file here: "E:\FTP\SBI\Archive\Test_l
----------------
I do have another package where I copy a file to an archive location, but I'm building the files with variables, etc. I just thought I'd create a simple package for another task and just not quite grasping how SSIS is thinking . . .
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.