Export data from SQL Server to Teradata

[Richard70]

Hello everyone. I am using VS 2008. I need to pull data from a SQL Server table and insert it into a Teradata temp table. This temp table will join to a view in Teradata. The result set needs to be exported back to SQL Server. I've created a Global Table, but can't see it through an OLE DB or an ADO connection. Any help on how to do this would be appreciated!

Thanks.

 

[sparkbyte]

This may help you.

http://ssisctc.codeplex.com/wikipage?title=Attunity&referringTitle=Home

Thanks

John Fuhrman

 

[Richard70]

- Thanks John for your suggestion. I appreciate it! Unfortunately, I am restricted from downloading anything from the Internet. I do have OLE DB for Teradata, and can connect to the table from SSIS.

Can someone please tell me how Global Temp Tables work in Teradata? Apparently, a connection to Teradata creates an instance of the table, and any data inserted into it is associated with that instance. I am using Data Flow Tasks in SSIS 2008 to insert data into a temp table. When I reference the temp table in a separate Data Flow Task, I get another instance of the table, which is empty. I'm using 'On Commit Preserve Rows'.

With Teradata SQL Assistant, I can insert data into the temp table, and retrieve it. But, if I drop the connection and reconnect, the data is gone. Can someone please tell me how to insert data into the temp table, and use it before the data is dropped? Thanks!

 

[gk53]

on connection properties make sure you have RetainSameConnection set to true