Export from SQL Server to Teradata Temp tables

Database
Enthusiast

Re: Export from SQL Server to Teradata Temp tables

Thanks for the welcome! I'm glad I found this site.

- I'm able to perform the join in SQL Server this time, however, any pointers on populating a temp table through SSIS would be helpful for future tasks.  I'm able to create a global table through Teradata Assistant, but I'm not able to find it within SSIS when connecting to Teradata through OLE DB or ADO.  Thanks everyone.

Not applicable

Re: Export from SQL Server to Teradata Temp tables

what is a global temporary table in teradata?

Junior Supporter

Re: Export from SQL Server to Teradata Temp tables

Vasu,

A global Temporary table is a temporary table that uses temporary space for the storage. A base definition of the table is stored in the data dictionary, an instance of this table is created with each create temporary table definition. Temporary tables survives a system restart, so more suitable for automatic scripts to avoid failures. Other tables kinds volatiles and derived tables do not survive a restart.

You can read more about this here:

http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1184_111A/Crea...

Khurram
Not applicable

Re: Export from SQL Server to Teradata Temp tables

I have the exact problem as Richard, but my data is too large to bring it down to SQL Server.  Any thoughts on how can I create a TD volatile table from SSIS ?

Thanks.