Post reply

Access connection properties from a script task

  • January 11, 2010 at 7:03 pm

    #141599

    Is it possible to access connection properties from a script task on a Control Flow? I have not seen any examples of accessing package objects from within a script.

    .

  • January 11, 2010 at 7:40 pm

    #1102145

    Answered my own question. Never mind. If anyone else is interested. Here's what I needed to get the file name from my flat file destination:

    string FileNameStr = Dts.Connections["MyConnectionName"].ConnectionString;

    .

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

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