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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ETL between two non-linked SQL servers

Status
Not open for further replies.
wbodger

wbodger

Programmer
Apr 23, 2007
769
US
I have two servers, both running SQL Server 2016 and I need to copy ~12 tables from one server to another, transform (link to a table on destination server and change businessid) and then load into the same server name on new server. My question is: Can I do this in one statement(pull data from source, join to table on destination and then load into destination tables), or is it best broken down into Extract (copy to second server holding table) transform and load (join to conversion table, pull new ids and then load into the final destination table)?

Thanks,
Willie
 
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
SSIS in SQL Server 2022
Replies
4
Views
343
grnzbra
grnzbra
Cpreston
  • Locked
  • Question
CSV to SQL table with not allow null issue
Replies
3
Views
286
Cpreston
Cpreston
marydn
  • Locked
  • Question
Send Nicely Formatted SQL Query via Email
Replies
0
Views
313
marydn
marydn
minhtran360
  • Locked
  • Question
Where do I look for my SSIS pasckage that just being deployed to my sql server?
Replies
1
Views
600
mark williams
mark williams
Newbie SSIS
  • Locked
  • Question
Using checkpoint in SSIS ETL for DFTs
Replies
0
Views
169
Newbie SSIS
Newbie SSIS

Part and Inventory Search

Sponsor

Back
Top