I switched to using a File and not a variable, then had this file have
its connection set dynamically in a expression. This did not work. I
then called the dts.connections("fileName").aquireConnection(Nothing)
to reset it prior to the task firing and this still didn't do
anything.
Let me know if anyone has any ideas.
Thank you,