Unix Technical Forum

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

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 ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > SQL Server

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-29-2008, 01:51 PM
evan
 
Posts: n/a
Default DTS question: 2 source tables, 1 target, 3 connections

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:18 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com