Post reply

ssis question

  • October 3, 2013 at 1:27 pm

    #283977

    i have a proc that is getting called and returns a filename that loads into cache in ssis. How do i then make a connection to that file? I dont see anywhere in the connection manager a way to full the filename from the result set

  • October 3, 2013 at 1:59 pm

    #1655684

    You need a variable that has scope for the whole package. Assign the filename to the variable look for the Property "Expressions" in the connection properties. In there you can change the properties and assign the value of the variable.

    I hope is clear enough, I usually don't answer SSIS questions :-D.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply