What is "a" and what is "b"... they are not in the table you described.  I realize there is a bit of a language barrier problem here, but do the...

Export to text file.  Use SQL*Loader to load the text file.  Stop using DTS.

Learn what?

Basic SQL?

ANSI SQL?

T-SQL?

Advanced T-SQL?

Performance tuning?

???

Are you doing this using embedded SQL in your VB code?  If you are, that is likely the problem...

Instead of telling us how you want to do something, it would be much more beneficial to yoru cause if you told us what you wanted to do and why....

...and why are you using a cursor?

It tells you...

USE Northwind

EXEC sp_SpaceUsed Customers

name      rows        reserved           data               index_size         unused             
--------- ----------- ------------------ ------------------ ------------------ ------------------ 
Customers 91          104 KB             24 KB              80 KB              0 KB

Heh... DTS?  I don't ever use it .

There might be a more effective way but I'd need to see what you have in...

Not sure what you mean, Steve

>>Performance differens is insignificant...

Is that good or bad?

Unfortunately, that would include me... can't afford the time... I'm too busy fixing performance problems for other folks

Same way it always does, Remi... someone will make a justification something like "Well Jeff, it depends..."   Six months later, they'll be scrambling to...

Like I said, fishing is good in the performance world... didn't even have to search for it... was the next item for me on "Active Threads"...

For all of those that think...

Oh my... Steve, you sure do know how to press the buttons   You basically brought the guns to bear on two of my...

Uh-huh... they need two special controls... one is a "Run SQL Faster" button and the other is a slide control to adjust the knowledge level of the developers writing code...