Post reply

Invoking Teradata Fastexport utility using SSIS

  • April 25, 2012 at 6:44 am

    #259889

    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

  • May 4, 2012 at 6:27 pm

    #1483783

    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