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 SkipVought 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
0
0
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
  • Question
SSIS in SQL Server 2022
Replies
4
Views
137
grnzbra
grnzbra
marydn
  • Locked
  • Question
Send Nicely Formatted SQL Query via Email
Replies
0
Views
113
marydn
marydn
minhtran360
  • Locked
  • Question
Where do I look for my SSIS pasckage that just being deployed to my sql server?
Replies
1
Views
105
mark williams
mark williams
Newbie SSIS
  • Locked
  • Question
Using checkpoint in SSIS ETL for DFTs
Replies
0
Views
75
Newbie SSIS
Newbie SSIS
hamzam
  • Locked
  • Question
Increment a series on sql
Replies
0
Views
38
hamzam
hamzam

Part and Inventory Search

Sponsor

Back
Top