July 12, 2011 at 2:22 pm
Here is the expression that I am using for my Flat File Connection manager.
@[User::vStagingDataFileDir] + "\\"+ @[User::vCurrentDataSet] + "\\FIXED.FILE.NAME"
When I execute the package, I get the following error the Data Flow Task:
[Flat File Source [94]] Error: Cannot open the datafile "C:\MyData\\FIXED.FILE.NAME".
[SSIS.Pipeline] Error: component "Flat File Source" (94) failed the pre-execute phase and returned error code 0xC020200E.
The first variable is retrieved from SQL Stored Package Configuration and is being set correctly.
The second variable is set by executing a stored procedure (output parameter) in the previous step The stored procedure does execute and output the correct parameters but does not appear to be set the Package Variable
I have set DelayValidation to true to avoid an error on the first pass through.
Any thoughts on how set the directory correctly?
July 13, 2011 at 1:00 pm
As it turns out, and after much research, I had to switch the execution of the stored procedure from a OLEDB Data Source Connection to a ADO.NET Data Source.
The parameters (both input and output) are now set correctly for the dynamic path.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply