• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 446
  • Last Modified:

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 . . .
0
Alaska Cowboy
Asked:
Alaska Cowboy
1 Solution
 
DultonCommented:
A couple thoughts:

It sounds like you're trying to do a "Data Flow Task" which would require a sender and a receiver to be established up front instead of a "File System Task", which will let you perform filesystem tasks create/copy/move/delete, etc.

Secondly... and this is a side issue. use caution when you're using drive letters, because they're only relative to which the machine you're using them on.... Typically I'd recommend using UNC path, since it is standard across your network, regardless of development/production machines.
For example F:\ may be mapped to \\server1\directory1\ShardDocs\ on machine A, whereas machine B may have F:\ mapped to \\machine 123\SharedFiles\
....So, if you use \\server1\directory1\ShardDocs\ in lieu of F:\ there won't be any confusion within your network..... FYI...if you're going to build these with expressions & variables dynamically, you have to double up on the backslashes.... \\\\server1\\directory1\\SharedDocs\\
-Completely a side note, but figured i'd mention while I was at it.
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now