Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Monday, January 25, 2016 10:47 AM
Points: 26, Visits: 302
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, August 18, 2016 12:45 PM
Points: 2,600, Visits: 3,386
Umm.... how about the double back-slashes ("\\") ? Shouldn't those be single back-slashes ("\") ?


Steve
(aka sgmunson)

Health & Nutrition
Post #1446991
Posted Thursday, June 6, 2013 6:05 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Saturday, March 5, 2016 9:04 PM
Points: 621, Visits: 597
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"


Raj
Post #1460640
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse