How to Import Data/Tables from Teradata to MS SQL Database?

Question

Hi all I need to import Teradata data or tables to MS-SQL database tables. How is this possible? And what technique will useful for this process. Please give me some suggestions.

Manish Kumar · Answer

Apart from Nitin answer another option we can make linked server from Sql server to your tera data database. Here is a link which helps to make linked server and other stuff. https://developer.teradata.com/blog/netfx/2011/12/setup-sql-server-2008-r2-linked-server-to-the-teradata-database Thanks Manish

Nitin Sontakke · Answer

You should be looking into SQL Server Integration Services (SSIS). While it may look intimidating at first trust me it is very simple should you approach it without any preconceived notions.

Nitin Sontakke · Answer

Please also note that you would need Microsoft Visual Studio Data Tools installation etc. and other IDE prerequisites.

Nitin Sontakke · Answer

Just google the SSIS Tutorials SSIS Sample etc. and you would gets literally loads and loads of hits for blogs videos reference material etc. Pick and choose the one which suits you best. You may add even Teradata data source as well if you wish so as to get specific hits. I will be doing the same to answer your question.

Hariharan Krishnamoorthi · Answer

Hi Nitin Sontakke Could you please share me some sample website links to achieve this.