Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Teradata provider is not listed in the SSIS connection manager Expand / Collapse
Author
Message
Posted Friday, March 29, 2013 3:08 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 3, 2013 2:44 PM
Points: 60, Visits: 237
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
Post #1437101
Posted Friday, March 29, 2013 4:08 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:53 PM
Points: 2,205, Visits: 5,515
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
Post #1437125
Posted Friday, March 29, 2013 6:25 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, April 3, 2013 2:44 PM
Points: 60, Visits: 237
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!.
Post #1437164
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse