DSN

Just browsing and looking at some posts.

This one is very old, still worth answering?

Ah....why not.

1. Create the DSN.
2. Open the registry.
3. Export HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\%Data source name%
4. Import that key into your package.
5. You can also import the DSN in Wise
a. Installation Expert | ODBC | Add | Data Source
b. Click Import, select the DSN you created.
This is not necessary when you imported the reg.keys and for some it doesn't work at all, but just so you know and so you can play with it.

When an application creates a User DSN, first try to make it a System DSN. 9 out of 10 times it will work. For the 1 time that you do need the User DSN, I use Active Setup to install the User DSN.