July 28, 2011 at 9:45 am
I have a data flow task that retrieves some data and then processed by a Flat File Destination which creates the text file with no errors. I then need to copy the file to a new destination for example CRVCOIndexBuildFile.txt to CRV_20110715.csv, but the file is never created and no errors, in fact the Execution results show everything normal. This is processing on my local drive, verified permissions not an issue.
File copy is setup as:
IsDestinationPathVariable - True
DestinationVariable - User::strCRVCOIndexFileNameOnly
OverwriteDestination - True
Operation - Copy File
IsSourcePathVariable - False
SourceConnection - CRVCOIndexBuildFile Connection Manager
Here's the weird part. If I change OverwriteDestination to false, I get an error that the file already exists, but that file doesn't exist when displaying the directory. If I change IsDestinationPathVariable to False and use a connection manager it works, but I can't do this as this is in a loop processing multiple files.
I'm throwing message's, breakpoints, deleted the task and recreated and cannot get this to work.
Need some help here, thanks!
*** Update ***
Case of HUYA, turns out I was missing the path to the file in my var where as it's specified in the 'connection' based test, I have no idea where it was creating the file as a system search returned nothing, but issue is now resolved.
Mark
July 28, 2011 at 2:40 pm
Thanks for posting back...I learned a new acronym too 😀
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply