I've Inherited an old SSIS package and am currently trying to move it to a proper SSIS solution/project. Everything seems ok apart from the dynamic connections which I can't get to work. The error is "The file name "\Server\Folder2\Folder1\Filename1_" specified in the connection was not valid"
The dynamic connection is specified as follows, which puts rundate on end:
There is a dynamic expression for the file location so I'm a bit confused as to what the defined flat file connection should be. I created a couple of files with just the column headers to create the static connection mapping, however, once you connect to it an then close the connection manager, then reopen it, it has reverted to the old connection and says "a valid file name must be selected."
at the bottom.
I've turned off DelayValidation and tried changing Unicode setting to True on one of the connections to no avail.
Any thoughts on what should be defined for the static connection in the connection manager if using a dynamic connection for the output file?