SQL to Teradata RRS feed

  • Question

  • Hi all,

            I have a SQL DB whihc has a table "Table_List" whihc holds the names of the tables that needs to be backed up. The back up process is as follows.

    1) For each table in the SQL DB , same table schema exits in the teradata db.

    2) Loops to the table names in the "Table_List" table , fetch all records from that table & insert it into the destination table (same schema as the source) in teradata DB.

    I need to develop one generalised SSIS package for the same.

    Since this is a generalised one , i cannot use the OLE DB source & destination whihc required column mapping. Is there any other better way to get this done?




    Friday, January 28, 2011 12:56 PM


All replies