Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Compare Values In A Simple Transfer
Thanks for your help. I was hoping to be able to use the graphical tools in DTS Designer, instead of "clean" SQL, but your suggestion does exactly what I need. :o) Nemiz- Nemiz
- Post #6
- Forum: Microsoft SQL Server: Data Transformation Services
-
Compare Values In A Simple Transfer
Come on people! Please help me... My mind just can't comprehend, why it isn't possible to do a simple compare, before inserting via DTS. Picture the following: 1. You have created a simple DTS package that transfers data between to complety alike databases. One or more tables have primary...- Nemiz
- Post #4
- Forum: Microsoft SQL Server: Data Transformation Services
-
Compare Values In A Simple Transfer
No, the query is just an example of, what I want to do. I don't think it is possible to use to connections (servers/databases) at the same time in the Query Analyzer, but I have dont it in my "query", because it shows what I want the DTS to do. If you run the exact same query on two...- Nemiz
- Post #3
- Forum: Microsoft SQL Server: Data Transformation Services
-
Compare Values In A Simple Transfer
If I have 2 Connections - A Source and a Destination - which both have the same table (Table1) and I want to transfer values from the Source.Table1 that aren't already in the Destination.Table1, how do I do that? Something like: select * from Source.Table1 where Source.Table1.PrimaryKey not in...- Nemiz
- Thread
- Replies: 5
- Forum: Microsoft SQL Server: Data Transformation Services
