Teradata provider is not listed in the SSIS connection manager

• marees.inspire

  Ten Centuries

  Points: 1324

  More actions

  March 29, 2013 at 3:08 pm

  #275921

  Hi,

  We need to retrieve the records from teradata by using SSIS.

  We installed the teradata provider from the Teradata download site.

  After that: we tried to create the ADO.NET connection manager and select the teradata provider. but we are not able to see the Teradata provider listed in it.

  Could you please let us know what could be the issue and the resolution for this issue.

  Thanks in Advance!.

  Regards,

  Mareeswaran.

  6122035530

• prvmine

  SSCertifiable

  Points: 7007

  More actions

  March 29, 2013 at 4:08 pm

  #1602183

  I apologize; I miss read your post.

  You are using SQL server 2005 not 2008.

  MS did have “Microsoft Connector v 1.1 for Teradata by Attunity”

  however the down load from MS is no longer available.

  I would suggest using "Microsoft Connector for Teradata by Attunity" provided your SQL Server 2008 is Enterprise version.

  Download these files

  AttunitySSISTeraAdaptersSetupX64.msi

  AttunitySSISTeraAdaptersSetup.msi

  from http://www.microsoft.com/en-us/download/details.aspx?id=29284

  You can download installation and configuration information from

  here http://msdn.microsoft.com/en-us/library/ee692365(v=sql.100).aspx

• marees.inspire

  Ten Centuries

  Points: 1324

  More actions

  March 29, 2013 at 6:25 pm

  #1602220

  Hi,

  I have downloaded the provides from the teradata site.

  It was working fine without any issues in test server. but it is not working in the stage server as expected.

  Thanks!.