Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
 Posted - 2006-05-25 : 10:04:26
|
| Hi all,This is, I'm sure, a very simple question - I'm sure I'm doing something stupid, but I'm battling to find it.Specifically:I need to look at copying a file from one location to another. Seems simple enough - I've located and dragged the File System Task from the Control Flow Items, onto my Control Flow. I set my destination connection to:USAGE TYPE: Create FileFILE: E:\Testing\Target\NewFile.txtI set my source connection to:USAGE TYPE: Existing FileFILE: D:\Testing\Source\FileToCopy.txtOn the File System Task, I set my operation to: Move Filethe IsDestinationPathVariable is set to FALSE, the OverwriteDestination is set to TRUE,the IsSourcePathyVariable is set to FALSE.When I execute, it fails - the relveant issues from the progress seem to be:[File System Task] Information: File or directory "E:\Testing\Target\NewFile.txt\FileToCopy.txt" was deleted. [File System Task] Error: An error occurred with the following error message: "Could not find a part of the path 'E:\Testing\Target\NewFile.txt\FileToCopy.txt'.". What I can't determ ine is how it is generating that bad trarget location - I'm not sure what it is combining to get that address.Anyone help me out?*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2006-05-25 : 10:08:43
|
| set blush mode to BRIGHT RED...Found it... I need to only be specifying a target directory, since I was moving file. When I changed the USAGE TYPE property on the File Connection Manager for the target, iot worked fine.set blush mode to normal*##* *##* *##* *##* Chaos, Disorder and Panic ... my work is done here! |
 |
|
|
|
|
|
|
|
NEw to SSIS - trying to do file copy