Post reply

how to use existing oledb connection in script task

  • December 8, 2008 at 6:27 am

    #216179

    Hi Friends,

    I have an existing oledb db connection in connection manager, how can I use the same connection in Script Task to fill a datatset.

    Can anybody help me?

    Vaseem

  • December 8, 2008 at 11:39 am

    #909280

    I would just use a Execute SQL task with full resultset before the Script task to store the result set in an object type variable and then use something like this in the script code

    oleDA.Fill(dt, Dts.Variables.Item("vResultSet").Value)

    oleDA is of type OleDbDataAdapter.

    HTH

    ~Mukti

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

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