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)  Updating a different data source

Author  Topic  lbodie Starting Member 4 Posts Posted - 2005-04-13 : 10:11:44 I have a DTS package with a SQL table and a Progess table. I need to UPDATE rows in the Progress table with some data from the SQL table. I am really struggling on how to get this done. I am manually doing in Access since I can write a simple query that joins both sources. Can anyone help? Thanks