Solved

Can't copy file from one location to another in SSIS

Posted on 2013-06-26
1
430 Views
Last Modified: 2016-02-11
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
Comment
Question by:Alaska Cowboy
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 6

Accepted Solution

by:
Dulton earned 250 total points
ID: 39290538
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

690 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question