#DateForumTypeThreadPost
921 Feb 2014 @ 03:34 PSTDatabaseReplyDelete table from within SSISThanks again to you both!   Your answer worked perfectly Khurram!
819 Feb 2014 @ 03:56 PSTDatabaseTopicDelete table from within SSISHello everyone.  I am looking to delete all data in a permanent table in EDW from within an SSIS package.  I have an OLE DB connection to Teradata.  Do I need to create a Stored Proc...
719 Feb 2014 @ 03:50 PSTDatabaseReplySSIS and Global Temp TablesThanks Adeel for your advice, and thanks Saeed for your help too.  I was able to create a permanent table in EDW, and that solved it. You guys really rock! 
618 Feb 2014 @ 10:32 PSTDatabaseTopicSSIS and Global Temp Tables Hi. 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 w...
510 Feb 2014 @ 11:55 PSTDatabaseReplyExport 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 w...
407 Feb 2014 @ 08:05 PSTDatabaseReplyExport from SQL Server to Teradata Temp tablesThanks Adeel!  I'm looking at creating a global table through an ADO connection to Teradata.  If I'm not able to create the table, I'll pull it to SQL Server as you suggested.
306 Feb 2014 @ 03:01 PSTDatabaseReplyExport from SQL Server to Teradata Temp tablesThanks again!
206 Feb 2014 @ 03:00 PSTDatabaseReplyExport from SQL Server to Teradata Temp tablesThanks Adeel and Saeed for your responses.  I don't have permission to create a permanent table on the server. (What is the difference between a global table and a permanent table?) A glob...
105 Feb 2014 @ 04:04 PSTDatabaseTopicExport from SQL Server to Teradata Temp tablesHello.  I am trying to export data from SQL server to a temporary table in Teradata.  The temp table will then be joined to a view in Teradata, and the results exported back to SQL server...