MS OLEDB Stage

bensonian · Post by **bensonian** » Thu Sep 07, 2006 1:18 pm

Hi

I got a few questions regarding the stage.

1.Is MS OLEDB Stage a server job stage or can it be used for EE (7.5.1 ) too?
2. Say i wanna use the MS SQL Server Load Stage. Inspite of using an ODBC driver (either Wire or No-Wire protocols) if i wanna go for a OLE DB driver should i be using the MS OLE DB stage prior to MS SQL Server Load stage?

3. Do we have a OLE DB driver that comes with DataStage Enterprise Edition ( no luck..checking the Installation and Plug-in guide)

If some guru's out there can shed some light on this... your help would certainly be appreciated.

ray.wurlod · Post by **ray.wurlod** » Thu Sep 07, 2006 3:50 pm

1) No.
2) No. It's not necessary or even desirable.
3) No. There's no such thing as an OLEDB driver. Anywhere.