ssis flat file destination connection manager has invalid usage type folder exists.
I am using a variable with source location. I have a flat file connection connection string references \\snap3\share1\uploads\xxx\Archive and expressions is @[User::Dest_Dir] +RIGHT("0" + (DT_STR,4,1252) DatePart("yyyy",getdate()),4)+ Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) + Right("0" + (DT_STR,4,1252) DatePart("d",getdate()),2) + ".txt"
the flat file connection is usage type existing folder the folder is \\snap3\share1\uploads\Autonation\Archive
Now of course the folder exists it is supposed to.
I have no idea how to fix this and i just want to rename the file with a date so i can close this task. It is the last piece. Does anyone have any idea.
asked Apr 18, 2014 at 08:26 PM in Default
The flat file connection you gave has its connection string referencing
Whereas the folder that you guarantee to exist is the folder
Both are different paths! This could be the source of error.