title: SSIS Teradata ole db connection
body: <p>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? </p>