Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

File system task error - Could not find a part of the path Expand / Collapse
Author
Message
Posted Tuesday, September 30, 2008 9:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 2:30 PM
Points: 104, Visits: 317
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.
Post #578385
Posted Tuesday, September 30, 2008 9:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 20, 2009 3:23 AM
Points: 39, Visits: 200
check the issourcepathvariable true.IsDestinationPathVariable True and OverwriteDestination True .It might helps.


Post #578406
Posted Tuesday, September 30, 2008 10:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 14, 2014 2:30 PM
Points: 104, Visits: 317
They are all true.
Post #578481
Posted Wednesday, March 25, 2009 7:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 4, 2013 8:56 AM
Points: 2, Visits: 10
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
Post #683262
Posted Wednesday, March 25, 2009 7:14 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, February 4, 2013 8:56 AM
Points: 2, Visits: 10
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
Post #683271
Posted Thursday, February 27, 2014 3:03 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 12, 2014 9:51 AM
Points: 1, Visits: 48
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.
Post #1546142
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse