Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error with DTS Active Script Expand / Collapse
Author
Message
Posted Monday, August 12, 2013 10:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, August 13, 2013 12:50 PM
Points: 1, Visits: 15
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

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!




Post #1483390
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse