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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using DTS to transform Replicated data

Status
Not open for further replies.
Catadmin

Catadmin

Programmer
Joined
Oct 26, 2001
Messages
3,097
Location
US
Has anyone ever used DTS with Replication? I see this option is available, but I'm not sure how to implement it. All I need to do is change the names of a few columns.

Any ideas?



Catadmin - MCDBA, MCSA
Beware the error of pre-emptive poultry inventory!
 
Sort by date Sort by votes
could'nt you just use Query builder from DTS and select source tables to your target using column alias'

I was the first American Soldier to put a basketball hoop up in Iraq, only to have it stolen by a soldier from different camp. Newbee - Adam
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ItHurtsWhenIThink
  • Locked
  • Question Question
Using Distinct and count in same query???
Replies
4
Views
804
gk53
gk53
botatun
  • Locked
  • Question Question
the linked server insert data to csv in wrong order
Replies
0
Views
610
botatun
botatun
Fsoumia
  • Locked
  • Question Question
DTS Logging
Replies
2
Views
744
Fsoumia
Fsoumia
Azzuri
  • Locked
  • Question Question
DTS To SQL Server 2008
Replies
1
Views
421
mrdenny
mrdenny
mutley1
  • Locked
  • Question Question
XLSX import to DTS (SQL 2000)
Replies
0
Views
367
mutley1
mutley1

Part and Inventory Search

Sponsor

Back
Top