?
Solved

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

Posted on 2013-06-26
1
Medium Priority
?
436 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 1000 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
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 tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

762 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