Solved

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

Posted on 2013-06-26
1
425 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
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SHOWPLAN permission denied in database 'AdventureWorks'. 13 111
SSRS 2013 - Overlapping reports 2 32
SQL DATEADD 10 70
Please explain purpose of GZIP 4 34
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
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…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

856 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