CODEWITHSUNDEEP
ssisteradata
Nathan J.
Nathan J.

Reputation: 13

SSIS Teradata ole db connection

I'm working on modifying an SSIS package that includes several lookup transformations. In my experience you must have an OLEDB connection created to use a lookup. I am being asked to change the lookup to connect to a Teradata connection. We have installed the Attunity drivers and Teradata is an option under ADO.NET connections but not under native oledb connections. For reference I see the native oledb for Oracle. How do I create a connection to Teradata that I can use in a lookup or an ole db command?

Upvotes: 1

Views: 3729

Answers (2)

Andrew
Andrew

Reputation: 8703

As for the Teradata driver, you can download the OLEDB driver from Teradata, available here

Upvotes: 1

billinkc
billinkc

Reputation: 61211

For 2008+, you have two options for a Lookup Component. The first is to use an OLE DB Connection Manager. For all other Connection Manager types, use a Cache Connection Manager

Add a Data Flow, I usually call mine "Warm Cache" where you use your source, an ADO.NET Source and route it to a Cache Transformation destination. When your package begins, it will dump all the data to the CCM.

Then, in your "actual" data flow, change the Connection type to reference the Cache you populated in the previous step.

Upvotes: 2

Related Questions