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 manasger Expand / Collapse
Author
Message
Posted Friday, March 29, 2013 3:06 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 #1437100
Posted Wednesday, April 24, 2013 7:51 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 9:41 AM
Points: 434, Visits: 664
Do you need to set up a ODBC DSN on the machine. My experience is with Progress rather than Teradata but I think it is the same for most .NET and ODBC/JDBC connections.

If you do then you will need to make sure that the correct drivers are installed on the server and that the DSN is also set up there. I have the pleasure of developing in XP 32bit and deploying to W7Server 64bit which generally causes chaos!
Post #1445982
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse