April 25, 2013 at 11:33 am
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)
April 26, 2013 at 7:33 am
Umm.... how about the double back-slashes ("\\") ? Shouldn't those be single back-slashes ("\") ?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
June 6, 2013 at 6:05 am
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"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply