By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,238 Members | 1,659 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,238 IT Pros & Developers. It's quick & easy.

DTS question: 2 source tables, 1 target, 3 connections

P: n/a
I am converting a sp that joins 2 OPENQUERY statements to populate a
target table into a DTS package.

I have the following SQL statement (whichs execute without error) that
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 from
OPENQUERY("SVR-1",'SELECT sku_id, style_id, style_color_id,
style_size_id FROM merch.dbo.sku') as AX, OPENQUERY("SVR-2",'SELECT
sku_id, style_id, color_id, size_master_id FROM ma.dbo.sku') as AY
Where AX.sku_id = AY.sku_id

The issue I am having is that I do not know how to use 3 connections
to do this. I have one table that is being loaded from tables on two
different servers. Although they are currently linked servers, I want
to be able to run the existing query using a DTS package. I just do
not know how to set up three connections. I have no problem with two
connections, just three.

Does anyone have experience with setting up a DTS package to insert
into the target table data from 2 other connections, where the
connection inserting into the target table is extracting from yet a
third connection?

I found some references to transformation lookup and was wondering if
anyone reading this has done this before.

Nov 8 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.