Resender (9/1/2015)
Ok quick scenario,our primary file server is changing between today (Sep 1 2015) & the next 6 months.On this file server we have a share where we put flat files that we process using SSIS.
So we are going to change the packages to work with dynamic flat file destination/sources.
We're putting the 'share' location in a SQL table called SSIS_Parameter.
Now we have a test package,works fine,however we were wondering whether or not the dynamic destination was actually rendered @ runtime.
We found it wasn't,since we had put the actual share name in the variable,it looked like it was changing at runtime but it wasn't.
So changing it to an non-existing location broke the package, changing the share variable to "C:\" and the value in the table to "\\sharename\",seem to work.
Now I don't need a solution,just a second opinion on this.
Since you have not gone into detail about exactly how the 'dynamic destination' is being set, I cannot help with any specifics.
But it is most certainly possible to do. All of our flat file source and destination paths are dynamically controlled from SSIS Environments using parameters. I know that you said that you did not want a solution, but if you're on SSIS 2012+, I would think very hard before ignoring SSIS environments and rolling your own solution.
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.