MS OLEDB Stage
Posted: 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.
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.