looking for a faster way to gather records

[michelleHEC]

Right now I am using a datareader and a do while loop to gather records and then using a dataset I am inserting the data into another table. I have 60000 records to go through and it is taking hours. Is there a faster way?

Thank you in advance,
Michelle

 

[ThatRickGuy]

how are you importing the data from the reader to the dataset?

Can this be done via a DTS package (SQL Server) or other automation process (like SQL Loader)?

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[michelleHEC]

they want me to gather the information from oracle and dump it into sql every night. I can't build a DTS package from oracle to sql. so right now i am using oledbcommand, reading it and then inserting it into sql. is there a way to create a dataset from the oracle connection and then copy it into the sql dataset??

 

[RiverGuy]

DataReaders/DataSets, etc are the wrong technology for doing bulk load processess. Look at this article for a comparison of some of the technologies to do this:

http://www.sqljunkies.com/Article/650DF949-148D-46B3-9156-6783646F976D.scuk

I'm not sure why you can't use a DTS package which would be the easiest--you can even schedule it on the sql server.

 

[michelleHEC]

we do not have a license for oracle to do a link server (according to our administrator) i am going to read the article though. thanks

 

[chrissie1]

you don't need the license just a odbc driver wich are free.

Christiaan Baes
Belgium

I just like this --> [Wiggle] [Wiggle]

 

[ThatRickGuy]

I'm with Chrissie, if you have an ODBC connection, you can use DTS. If you don't want to use DTS, grab a copy of SQL Loader which is basicly a third party tool that will do the same thing.

-Rick

VB.Net Forum forum796 forum855 ASP.NET Forum
I believe in killer coding ninja monkeys.

 

[michelleHEC]

Thanks to all of you. I disregarded what my administrator said and used the ODBC connection and created a DTS. It worked wonderfully. Thanks again, I don't know what I would do without tek-tips!