August 12, 2015 at 2:40 am
Hi ,
I am working on SSIS package where I have to deploy the package on CATALOG.
I deployed the my project on SSISDB catalog.
In my package on Script task and container is there.In container DFT where source is flat file and destination is OLEDB .
1st task is Script task which is checking if file exist or not if exist it will go to container if not it will skip.
This package working fine when running through BIDS.
But when trying to run from catalog I am getting error
Error Code: -1071636466
Error Description: Cannot open the data file "H:\Spectrum_V2_ETL\Loading_Geography_Table_Data\MD_GEOGRAPHYLEVELXREF_US.txt".
but MD_GEOGRAPHYLEVELXREF_US.txt file exist in folder then also it is getting fail.
regards,
Vipin jha
August 12, 2015 at 3:13 am
Use a UNC path. Do not rely on network drive letters.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply