all groups > sql server dts > november 2005 >
You're in the

sql server dts

group:

Paradox import to 2005


Paradox import to 2005 JeremyGrand
11/5/2005 10:30:24 AM
sql server dts:
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?

Re: Paradox import to 2005 Jeremy
11/5/2005 11:50:14 AM
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


[quoted text, click to view]

Re: Paradox import to 2005 Allan Mitchell
11/5/2005 7:23:36 PM
For SSIS specific issues go here

http://forums.microsoft.com/msdn/showforum.aspx?forumid=80&siteid=1


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

Allan


[quoted text, click to view]
Re: Paradox import to 2005 Allan Mitchell
11/5/2005 9:02:51 PM
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




[quoted text, click to view]
AddThis Social Bookmark Button