This is a discussion on DTS question: 2 source tables, 1 target, 3 connections within the SQL Server forums, part of the Microsoft SQL Server category; --> I am converting a sp that joins 2 OPENQUERY statements to populate target table into a DTS package I ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I am converting a sp that joins 2 OPENQUERY statements to populate target table into a DTS package I have the following SQL statement (whichs execute without error) tha I am required to make a DTS package out of INSERT tbl_Sku SELECT AX.sku_id, AX.style_id, AX.style_color_id AX.style_size_id, AY.color_id, AY.size_master_id fro OPENQUERY("SVR-1",'SELECT sku_id, style_id, style_color_id style_size_id FROM merch.dbo.sku') as AX, OPENQUERY("SVR-2",'SELEC sku_id, style_id, color_id, size_master_id FROM ma.dbo.sku') as A Where AX.sku_id = AY.sku_i The issue I am having is that I do not know how to use 3 connection to do this. I have one table that is being loaded from tables on tw different servers. Although they are currently linked servers, I wan to be able to run the existing query using a DTS package. I just d not know how to set up three connections. I have no problem with tw connections, just three Does anyone have experience with setting up a DTS package to inser into the target table data from 2 other connections, where th connection inserting into the target table is extracting from yet third connection I found some references to transformation lookup and was wondering i anyone reading this has done this before |