Home Forums SQL Server 2005 Business Intelligence Setting and the using a Variable in an ssis package for dynamic source file connection. RE: Setting and the using a Variable in an ssis package for dynamic source file connection.

  • You should step thru the script and see what the value of filename when you try to assign it to the SSIS variable. Look like the error message it's Empty.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]