Solved

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

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Columnstore Indexes - real-time operational analytics 1 34
View SQL 2005 Job package 16 43
Addition to SQL for dynamic fields 6 38
SQL Server 2012 r2 - Varible Table 3 24
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…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

770 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