Can we use any other stage other than MSOLEDB

ravikiran2712 · Post by **ravikiran2712** » Thu Sep 29, 2005 1:35 pm

hi,
Can we use any other stage other than MSOLEDB stage to access data SQL SERVER using the bulk load option or do we have an option in the MSOLEDB plug-in itself.
Any help would be appreciated,
Thanks,
Ravi

kcbland · Post by **kcbland** » Thu Sep 29, 2005 1:41 pm

Haven't looked lately, but what's wrong with command line BCP bulk loading a sequential text file? If you don't like the BCP stage, you can do it the old fashioned way and write your own script to load the data file.

ravikiran2712 · Post by **ravikiran2712** » Fri Sep 30, 2005 7:23 am

Thanks for your reply Ray,
Can i Use MS SQL SERVER load for this purpose. Any help would be appreciated.
Thanks,
Ravi

chulett · Post by **chulett** » Fri Sep 30, 2005 7:49 am

Hey - it's not always Ray that answers.

kcbland · Post by **kcbland** » Fri Sep 30, 2005 7:57 am

ravikiran2712 wrote:Thanks for your reply Ray,
Can i Use MS SQL SERVER load for this purpose. Any help would be appreciated.
Thanks,
Ravi

BCP is the "MS SQL SERVER load" utility.

ravikiran2712 · Post by **ravikiran2712** » Fri Sep 30, 2005 10:32 am

hi,
Thanks once again Kenneth. iam very sorry Ken as i thought i was replying to one more reply Ray posted to one of my question.
Thanks,
Ravi

ray.wurlod · Post by **ray.wurlod** » Sat Oct 01, 2005 12:52 am

That's cool, but I do need sleep sometimes.