Post reply

Use existing connection is activeX script

  • October 8, 2004 at 2:46 pm

    #162386

    Can you use an existing connection used in a transformation in a later activeX script within the same DTS package?  If so, how do you reference it in the script (get the connection string) to open a connection?  I want to create a recordset in the script using the existing connection.  The existing connection is a SQL Server 2K trusted connection so I am not passing any userID or password.

    Thanks

  • October 11, 2004 at 5:42 am

    #526122

    From your post I am not too sure what you are trying to do.

    However, at a guess, I would suggest creating and populating a global variable in the first activex task so that you can then use it later on in the package.

    You can create a global variable with an output parameter as rowset and build your recordset from the result of the sql query.

    Hope this helps.

    ------------------------------
    The Users are always right - when I'm not wrong!

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

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