Hi Gilles,

For ODBC sources you woud use MS OLE DB Provider for ODBC. To get Provider (connection) string, you can use ODBC Manager to create FILE DSN with options you want, open it in any text editor and copy it's contents into the Provider textbox of linked server.


>The provider that I saw un my DTS package definition is not available in the linked Server "Other Datasource"
>
>Is it normally all the providers (as available in the ODBC manager) that are accessibles ?
>
>Is there some kind of configuration that I need to do ?
>