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

Sybase to SQL Server 2000 using DTS

Status
Not open for further replies.
na1

na1

Programmer
Nov 26, 2002
2
GB
I am currently pulling in 60 tables from a Sybase database into SQL Server 2000. To do this I have set up 6 DTS packages each with 10 transformations, and a global package which runs each DTS.

Adding new tables is convoluted and can cause problems, and also transfer speed is quite slow as servers are remote from one another.

Is there a better way of doing this? Can the routine be driven dynamically from a list of tables we need to pull in? If this can be done then I would only need to set up one transformation.
Thanks in advanced.
 
Sort by date Sort by votes
We were pulling over about 35 tables and one quick way to get things setup is with the wizard. Our transformation was from Access to SQL Server. The wizard allows you to select all tables in a database.

This is much quicker than selecting each table individually and building the DTS package by hand.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

petart
  • Locked
  • Question
Problem Date MS SQL Server
Replies
0
Views
162
petart
petart
ItHurtsWhenIThink
  • Locked
  • Question
Using Distinct and count in same query???
Replies
4
Views
196
gk53
gk53
mutley1
  • Locked
  • Question
XLSX import to DTS (SQL 2000)
Replies
0
Views
74
mutley1
mutley1
Azzuri
  • Locked
  • Question
DTS To SQL Server 2008
Replies
1
Views
105
mrdenny
mrdenny
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
152
botatun
botatun

Part and Inventory Search

Sponsor

Back
Top