Feed Icon  


  • Bryant Likes
  • Send mail to the author(s) E-mail
  • twitter
  • View Bryant Likes's profile on LinkedIn
  • del.icio.us
Get Microsoft Silverlight
by clicking "Install Microsoft Silverlight" you accept the
Silverlight license agreement

Hosting By

Hot Topics


Open Source Projects



SQL Server 2005 DTS and ODBC Connections

Posted in Sql and Xml at Wednesday, July 28, 2004 3:23 AM Pacific Daylight Time

I ran into while using DTS in SQL Server 2005. If you want to use an ODBC connection you have to do the following:

    1. Pretend to create a ADO.Net SQL connection first (or managed OLEDB,
      whatever works).
    2. Select the connection in the connections tray and manually:
      change ConnectionString to "DSN=myODBC; " (or whatever your connection
      string is)
    3. Change Qualifier to "System.Data.Odbc.OdbcConnection, System.Data,
      Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"

[via SQL Server 2005 DTS Newsgroup]

Sunday, December 03, 2006 11:51:17 AM (Pacific Standard Time, UTC-08:00)
Hey, I found your post looking for how to use ODBC as a destination for dts in sql server 2005, I don't have either ado.net nor managed ole db as options. I can use MS OLE DB for datamining and use the DSN in the connection string, but I don't understand where to put this part: System.Data.Odbc.OdbcConnection, System.Data,
Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

could you email me? mantorp at gmail dot com

Tuesday, February 20, 2007 4:52:54 PM (Pacific Standard Time, UTC-08:00)
I havce the same problem could you post where to put the qualifier?

or send it by mail to guillermo.marichal at gmail dot com

Wednesday, March 28, 2007 1:02:48 AM (Pacific Standard Time, UTC-08:00)
ditto to above

Tuesday, October 23, 2007 1:24:55 AM (Pacific Daylight Time, UTC-07:00)
We are having a problem connecting from Informix to SQL Server 2005 using the SSIS import/export feature. We are trying to get an OLE DB driver that will make this work for the SSIS import/export feature. Right now the copy data feature is disable on the import/export and according to microsoft they no longer support this in 2005. It allows us to do it manually; but I was hoping that someone may have a work around for this so this can be done automatically rather than manually. Any idea's.

Comments are closed.