All Forums Connectivity
frittsm 1 post Joined 09/12
28 Dec 2012
SSIS 2012 OLE DB Teradata provider 'TDOLEDB.1'


I am trying to set up a connection in SSIS 2012 and get i the following error. 


Test connection failed because of an error in initializing provider. The 'TDOLEDB.1' provider is not registered on the local machine.



gt9430a 1 post Joined 01/13
07 Feb 2013

Hello, I'm having the same problem (Win Server 2008 x64, SSIS/SSMS 2012 x32).  I'd appreciate any info on how to get the TDOLEDB driver working as I'm hoping that it'll allow me to pass DDL statements through OPENQUERY in SSMS, or perhaps provide better performance than the Teradata ODBC driver.

rs122158 6 posts Joined 03/11
06 Mar 2013

Teradata only offers a 32-bit OLEDB Provider. Error may be the result of SSIS package running in 64-bit mode. Try setting package properties Run64bitruntime=false

Njambuya 1 post Joined 10/13
29 Oct 2013

Did you get your SSIS to work with OLEDB I am having the same problem

jmgimenez 3 posts Joined 03/12
14 Mar 2014

same problem here. Any solution?

wmmiteff 20 posts Joined 02/11
14 Mar 2014

Have you tried the .Net data provider for Teradata?  It seems to work better then OLEDB, just don't forget to modify the response buffer size.

NetFx 346 posts Joined 09/06
14 Mar 2014

Refer to
It will show you how to use a UD file (e.g. FOO.UDL) to test OLE DB connections.

jmgimenez 3 posts Joined 03/12
28 Mar 2014

I need to use OLEDB connection because I'm trying to make a Lookup transform so ADO.NET is not possibñe. My problem was TTU installation mess up my windows path. What I've done was to cut the path in two (user and system path) in order to don't exceed the character limit. Also I installed previous TTU (14.00) because 14.10 wasn't working.

rs122158 6 posts Joined 03/11
07 Apr 2014

Note, there is no 64-bit Teradata OLEDB, for 64-bit SSIS Lookup solution use .NET Data Provider for Teradata with SSIS Connection Cache Manager feature.

Niharika 1 post Joined 02/16
26 Feb 2016

Hi All,
I am trying to connect QlikView(64-bit) with teradata. I have Teradata in my machine.
Also have created a DSN in ODBC(64-bit).Now I have created a connection string by using Microsoft OLEDB Provider for ODBC Drivers and the connection string generated is in below format:

OLEDB CONNECT32 TO [Provider=MSDASQL.1;Persist Security Info=False;User ID=myuserid;Data Source=my data source;Extended Properties="DSN=mydsnname;UID=myuserid; "];(XPassword is mypassword);

Now when I use the same connection string and run a task, I am getting an error saying
The .Net Framework Data Provider for OLEDB (System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC (System.Data.Odbc). ||
I have tried changing MSDASQL to TDOLEDB, but then I am getting an error that TDOLEDB is not installed in Local machine.
Can anyone plese help me.

You must sign in to leave a comment.