Invoking Teradata Fastexport utility using SSIS
-
Can anyone please post the steps to configure SSIS package to invoke fastexport utility for bulk loading from teradata to sql server 2005? Also please let me know which type of database connectivity is required for using fastexport in SSIS?
It will be really helpfull as I am new to SSIS..
Regards,
Sumit
-
sumit.hitk.ghosh (4/25/2012)
Can anyone please post the steps to configure SSIS package to invoke fastexport utility for bulk loading from teradata to sql server 2005? Also please let me know which type of database connectivity is required for using fastexport in SSIS?It will be really helpfull as I am new to SSIS..
Regards,
Sumit
Hi Sumit,
Have you tried using the regular ADO.NET in combination with the Teradata ODBC driver to read data from Teradata and then load the data in SQL Server using OLE DB Destination component with FAST LOAD option? You should be able to get decent loading speed.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply