Error with DTS Active Script

  • >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

    I am trying to execute a script that will move data from one table in SQL to another table in SQL, but I'm running into an error...

    I am getting this error when executing...

    Error Source : ADODB.Recordset

    Error Description: Error Code : 0

    Error Source=ADODB.Recordset

    Error Description: Item cannot be found in collection corresponding to the requested name or ordinal.

    Error on Line 45

    FYI Line 45 is this line - Qty = trim(rs("Quantity"))

    Thanks in advance to anyone that can provide some input!

Viewing 0 posts

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