 |
 |
Archives of the TeradataForum
Message Posted: Wed, 17 Sep 2003 @ 21:20:24 GMT
| Subj: | | Production OLE DB Jobs |
| |
| From: | | Kristen Levit |
Hi,
I'm working with a client who is preprocessing data in SQL Server using existing jobs and is then loading the data into Teradata. He has
been testing OLE DB to transfer the data using the OleLoad tool and that has worked fine. Now the jobs need to be productionalized. Is
there a way to use the OLE DB access module so no manual intervention (ex. specify the source) is needed? In the Access Module Reference
Guide I can only find two modes of operation: In OleLoad mode or in prompt mode. Both modes bring up a dialog box in order for you to
specify the source data.
Any insights would be greatly appreciated.
Thanks,
Kristen
| |
