Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Update table field values using DTS

Author  Topic  dlakshmi Starting Member 1 Post Posted - 2005-12-09 : 06:25:04 Hi All, I am trying to update one database table fields into another database table fields through DTS. For that i used Data driven query transformation it is working fine. But it takes more than 2 to 3 mins to complete. My table having more than 3000 rows. Actually i followed below steps to create DTS package, 1. I added two connection objects with proper connections 2. I added data driven query in that i mentioned below update query, update [spadereport]..org_call set [spadereport]..org_call.auditstartdatetime=d.auditstartdatetime from [spadereport]..org_call s,[Spadebackup]..org_call d where s.callid=d.callid and i set below activex script. Function Main() DTSDestination("AuditEndDateTime") = DTSSource("AuditEndDateTime") DTSDestination("AuditStartDateTime") = DTSSource("AuditStartDateTime") Main = DTSTransformstat_UpdateQuery End Function Is there any other way to achieve this or how can i improve my DTS package execution speed? Dhana