I can create connection managers for paradox, either ado.net odbc or plain
old odbc, but what do I use them with? There seem to be no dataflow
components that can use these connections.

By the way, is there going to be an ssis forum someday?

For SSIS specific issues go here

http://forums.microsoft.com/msdn/sho...id=80&siteid=1


As for the connection manager to use can you not use the "Other
Connectiion" and an ODBC data Source?

Allan


"JeremyGrand" <jeremy (AT) spamlessninprodata (DOT) com> wrote

By "Other Connection" do you mean "New Connection" (right click in
connection mgrs tab)?

I can do this, but then what? None of the data flow sources will accept
this kind of connection.

However, I have found that if I create a named dsn, I can use the import wiz
to load the data. I choose save SSIS, and if I can ever find it, there
should be a package for me to study. Haven't found it yet though.

Thanks for the link to the forum.

Jeremy


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Ah so you are using SSIS and not DTS. My answer was for DTS and the
connection manager is the connections part of the "toolbox".

In SSIS if you right click in the connection manager's tray at the
bottom of your package then you should see a context menu

New Connection

Here you can choose ODBC or you can use ADO.Net and the choose the .Net
ODBC provider.

After creating a package with the wizard.

To Where are you saving the package?

SQL Server?

You will need to use Mmanagement Studio(Query Analyser on steroids) and
register the SSIS service to see the package.

File System?

You should be presented with a dialog that tells you to where the
package will be saved.


Allan




"Jeremy" <jeremy___ninprodata.com> wrote