SQL Server Performance Forum – Threads Archive
Updating RecordsetFollowing is my code to update a RecordSet, but it gives error that updating of recordset is not supported….
Any insight into this….
set RS = CreateObject("ADODB.Recordset")
set RS = DTSGlobalVariables("TableNames").value RS.MoveFirst
for countr = 1 to RS.RecordCount
RS("CompanionRecCount") = 0
Next Main = DTSTaskExecResult_Success
World Health Organisation
What is the exact error while executing the script?
Ensure necessary privileges are assigned to the login that executes the DTS package. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.
Prob this error might have happn’d due to the RS.Movefirst line. This is bcos, the RS is Forward Only and Read-Only in VBScript…
To overcome this u can try issuing "UPDATE" Query.
Check it… Seenu.