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

The system cannot find the path specified. Expand / Collapse
Author
Message
Posted Thursday, April 25, 2013 11:33 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, February 7, 2014 1:45 PM
Points: 26, Visits: 266
Below I am getting error for my package.

[Flat File [900]] Warning: The system cannot find the path specified.


[ Flat File [900]] Error: Cannot open the datafile "".

[SSIS.Pipeline] Error: component "Flat File" (900) failed the pre-execute phase and returned error code 0xC020200E.

------
I checked my variable path for flat file connection which is right.

"c:\\Paychex\\Custom-"+".csv" this is my path expression

and my csv file name is like (Custom-4232013123150.csv)

can you please help me out with this. Thanks in advance for your help.



(I am new with ssis)


Post #1446653
Posted Friday, April 26, 2013 7:33 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 6:05 AM
Points: 1,669, Visits: 2,220
Umm.... how about the double back-slashes ("\\") ? Shouldn't those be single back-slashes ("\") ?


Steve
(aka sgmunson)

Internet ATM Machine
Post #1446991
Posted Thursday, June 6, 2013 6:05 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 25, 2014 11:05 PM
Points: 338, Visits: 463
looking at the file name and expression, you are missing variable in your expression

The correct expression should be like this

"c:\\Paychex\\Custom-"+ @[User::variablename] + ".csv"


Joe
Post #1460640
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse