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
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: Tuesday, February 10, 2015 10:00 PM
Points: 60, Visits: 238

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!.

Post #1437100
Posted Wednesday, April 24, 2013 7:51 AM


Group: General Forum Members
Last Login: Today @ 7:14 AM
Points: 498, Visits: 760
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