January 14, 2004 at 6:00 am
Hi,
I have a large problem in making a "Inner Join" between Connections in a Data Driven Query.
I have two connections, one sql "Server_A" and one other server "Server_B".
Ive created a "Data Driven Query" which will read from "Server_B" and store the result on "Server_A" this works fine but the problem is that i get A LOT off information which i dont need...
I have an table on "Server_A" which contains some data which i need to join to "Server_B" so i only get the needed data.
*** What i have so far ***
Two connections: "Server_A" and "Server_B".
A "Data Driven Query".
Settings in the "Data Driven Query":
Source: "Server_B"
Sql Query: SELECT Field_A, Field_B FROM Database_B.Table_B
Destination: "Server_A" (The destination-table already exists).
Transformation: Field to field, correct...
Queries: INSERT INTO Database_A.Table_A (Field_A, Field_B) VALUES (?,?,?)
What i need is to make a "Inner Join" between "Server_A" to "Server_B" so i only get information from "Server_B" matching the second table on "Server_A"...
Hmm, if you understand this please respond... Hard for me to know what i meen...
Best Regards
Robert
January 14, 2004 at 7:26 am
Just a way!!
1. create a linked server
2. use a SQL Task to create a STAGING Table with your query
3. use that staging table as the source of your DDQ
* Noel
January 14, 2004 at 8:00 am
Solved the problem!
Created a ActiveXScript.
//R
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply