SSIS ERROR : SourceFlatFileConnection:
Not able to open the path when SSIS package runs.But manually when trying to open we are able to open the file path with no issues.
Error at line : Dts.Connections("SourceFlatFileConnection").ConnectionString = filepath.Trim()
Error : The file name is a device or the path is not valid. Request you to let me know any others suggestions on the same
Please suggest how to proceed on this further.
Thanks for help.
Check the account under which the SSIS job runs to see if that has access to the share / directory where the file is.
answered Jan 13, 2015 at 10:38 AM