September 30, 2008 at 9:13 am
I am trying to move a folder from one location to another and am using a file system task to accomplish this. I am using "Move directory" and variables for the source and destination. The to folder does not exist but \\File-02\DevSSIS\Applications\Results\Failure\ does exist.
The parameter values are
From folder: \\File-02\DevSSIS\Applications\Uploads\MarketBasket\NatlShare\PROCESSING_ABBIL_kbatta_20080918000000\
To folder: \\File-02\DevSSIS\Applications\Results\Failure\ABBIL_kbatta_20080918000000\
I keep getting the following error:
OnError,,,FST_ArchiveFailure,9/30/2008 7:40:49 AM,9/30/2008 7:40:49 AM,-1073548540,0x,An error occurred with the following error message: "Could not find a part of the path '\\File-02\DevSSIS\Applications\Results\Failure\ABBIL_kbatta_20080918000000\'.".
Both variables are set to EvaluateAsExpression true and the file system task has DelayValidation true.
I have tried the folder names with and without "\" at the end.
September 30, 2008 at 9:34 am
check the issourcepathvariable true.IsDestinationPathVariable True and OverwriteDestination True .It might helps.
September 30, 2008 at 10:50 am
They are all true.
March 25, 2009 at 7:01 am
Hi Mate,
It seems to be a bug in SQL Server if you supply a file name!
As a work around I have used 2 file system tasks. The first copies the file and the second deletes the original.
More info here - http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=180741
Jc
March 25, 2009 at 7:14 am
Hi Mate,
It seems to be a bug in SQL Server if you supply a file name!
As a work around I have used 2 file system tasks. The first copies the file and the second deletes the original.
More info here - http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=180741
Jc
February 27, 2014 at 3:03 pm
The better answer for this is to use rename. Rename will accept a new path and effectively do the same thing as your copy then delete, but in a single step.
February 18, 2015 at 10:33 am
Another solution for us was to use the IP address. It seems like SSIS/SQL Server had issues resolving the domain name.
August 3, 2015 at 10:09 am
Thanks, rename instead of move worked great!
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy