My SSIS package fails when it tries to read the source text file which is stored on a network share
[Connection manager "Dynamic Flat File Connection"] Error: The file name property is not valid. The file name is a device or contains invalid characters.
- I believe the sql account as well as my account has full permission to the folder
- The Message Box displays the filename and path correctly
- I have set Delay Validation to TRUE everywhere but still get the same error.
(Former Attorney General Bill Barr wrote a book titled "One Damn Thing After Another". That seems to apply to my situation.
Any ideas? Thanks