Bulk upload
-
Hi folks, I have a requirement to read data from a flat file and dump it into the database which is an oracle database. I know the best way to go doing about this is to use Microsoft DTS. But what a pitty, my project uses only oracle and .NET. I wanted to know whether there is a bulk load utility available to load data from flat,csv and excel file to database. i am not lookin at sql loader since this process should happen from App server and not from database server. Anyone has any inputs or suggestions.. Cheers, Venkatraman Kalyanam Bangalore - India "Being Excellent is not a skill, it is an attitude" Reality is an illusion caused by caffeine deficiency(one Microsoft Research scholor)
-
Hi folks, I have a requirement to read data from a flat file and dump it into the database which is an oracle database. I know the best way to go doing about this is to use Microsoft DTS. But what a pitty, my project uses only oracle and .NET. I wanted to know whether there is a bulk load utility available to load data from flat,csv and excel file to database. i am not lookin at sql loader since this process should happen from App server and not from database server. Anyone has any inputs or suggestions.. Cheers, Venkatraman Kalyanam Bangalore - India "Being Excellent is not a skill, it is an attitude" Reality is an illusion caused by caffeine deficiency(one Microsoft Research scholor)
Venkat, Have you tried Oracle Warehouse Builder http://otn.oracle.com/products/warehouse/pdf/Meta_DBMS_ETL_Tools.pdf[^] I've never used it, but came across this piece, where it was mentioning along with DTS, so thought this could do it. - Kannan
-
Venkat, Have you tried Oracle Warehouse Builder http://otn.oracle.com/products/warehouse/pdf/Meta_DBMS_ETL_Tools.pdf[^] I've never used it, but came across this piece, where it was mentioning along with DTS, so thought this could do it. - Kannan
Thanks kannan I had a look at it, and my initial impression is it will be a over kill for such a small functionality like which i have. Probably for a enterprise system it should be ok. My only job is to read line by line and insert into a table. i am looking at some BCP apis thanks again Cheers, Venkatraman Kalyanam Chennai - India "Being Excellent is not a skill, it is an attitude" Reality is an illusion caused by caffeine deficiency(one Microsoft Research scholor)
-
Thanks kannan I had a look at it, and my initial impression is it will be a over kill for such a small functionality like which i have. Probably for a enterprise system it should be ok. My only job is to read line by line and insert into a table. i am looking at some BCP apis thanks again Cheers, Venkatraman Kalyanam Chennai - India "Being Excellent is not a skill, it is an attitude" Reality is an illusion caused by caffeine deficiency(one Microsoft Research scholor)
Do you really travel between cities in between your posts or do you have a split personality by the evening :-) - Kannan
-
Do you really travel between cities in between your posts or do you have a split personality by the evening :-) - Kannan
Kannan Kalyanaraman wrote: Do you really travel between cities in between your posts Damn, you beat me to it. I was just about post the same question.. ;P
Never take a problem to your boss unless you have a solution.
This signature was created by "Code Project Quoter". -
Do you really travel between cities in between your posts or do you have a split personality by the evening :-) - Kannan
I guess you will understand if you are getting calls from client every other half an hour.. just kidding, little busy Cheers, Venkatraman Kalyanam Chennai - India "Being Excellent is not a skill, it is an attitude" Reality is an illusion caused by caffeine deficiency(one Microsoft Research scholor)