Page 1 of 1

MS OLEDB Stage

Posted: Thu Sep 07, 2006 1:18 pm
by bensonian
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.

Posted: Thu Sep 07, 2006 3:50 pm
by ray.wurlod
1) No.
2) No. It's not necessary or even desirable.
3) No. There's no such thing as an OLEDB driver. Anywhere.