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!

Fast DTS package to copy from SQL Server to OleDB (Access)

Status
Not open for further replies.
MuadDubby

MuadDubby

Programmer
Sep 23, 1999
236
CA
Hello

I'm trying to figure out a mystery. If I import an SQL Server table into MS Access (by using the import [not link] utility in Access), I can get a table of about 4.5 million records copied over in about two minutes. If I try creating a DTS to do this, it takes way more (I stopped it at about 250,000 records and it had already run for a minute).

Any ideas on hoe I could copy an SQL Server table to an OleDB destination with speed being the primary concern?

Thx,
.DaviD.
 
Status
Not open for further replies.

Similar threads

petart
  • Locked
  • Question
Problem Date MS SQL Server
Replies
0
Views
165
petart
petart
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
155
botatun
botatun
Azzuri
  • Locked
  • Question
DTS To SQL Server 2008
Replies
1
Views
111
mrdenny
mrdenny
mutley1
  • Locked
  • Question
XLSX import to DTS (SQL 2000)
Replies
0
Views
76
mutley1
mutley1
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
303
markjoseph1232
markjoseph1232

Part and Inventory Search

Sponsor

Back
Top