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

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 

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

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.

Hi Nitin Sontakke,

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

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.