Link to home
Start Free TrialLog in
Avatar of Alaska Cowboy
Alaska CowboyFlag for United States of America

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_load_file_2_output.txt" is not found."

-------------
a. My connection is called "Archive Conn", which points to E:\FTP\SBI\Archive\Test_load_file_2_output.txt

so why does it say "The connection "E:\FTP\SBI\Archive\Test_load_file_2_output.txt" is not found." ???
- there's no CONNECTION called "E:\FTP\SBI\Archive\Test_load_file_2_output.txt"

--------------
b. it seems as if I have to place the file here: "E:\FTP\SBI\Archive\Test_load_file_2_output.txt" 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 . . .
ASKER CERTIFIED SOLUTION
Avatar of Dulton
Dulton

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial