We have a number of DTS packages running on a SQL 2000 server, pulling data
from a non-relational accounting database.

The package is set up using an ODBC connection to this database, which uses
a system dsn on the machine.

I want to re-create all this over on a SQL 2005 system. I have installed the
ODBC driver which allows me to create the dsn, which tests successfully. I am
creating a new SSIS package to try this out, but am a bit stumped. I've
created a data source based on the dsn, which appears to work fine (and
appears in the connection managers), however I'm at a loss as to how to go
from here. I have been trying to create a data flow task to access the
accounting data, but the choices don't include (as far as I can see) and ODBC
connection, just OLE DB, which does not let me use the connection I set up.

I would have thought there would be and ODBC data flow source? In 2000, I
used a transform data task, but so far have not found it's equivalent in
2005. I'm sure I'm missing something obvious (I hope) - I'm just looking for
a way to use the odbc connection in a data flow task.

At this point, I don't want to just import the previous dts packages, as I'd
like to completely re-do them.

Any help would be most appreciated,

Thanks,

Tomt

Hi Tom,

Welcome to use MSDN Managed Newsgroup!

Yes, as you have noticed some SQL Server 2000 tasks do not map directly to
SQL Server 2005 Integration Services (SSIS) tasks

- Transform Data task
- Analysis Services task
- Data Driven Query task
- Dynamic Properties task

For more information, check the article below

Migrating Tasks
http://msdn2.microsoft.com/en-us/library/ms143552.aspx


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/

If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Create an ADO.Net connection, selecting the Odbc Data Provider.

You can then use the Data Reader source against this connection.

There is also an Integration Services newsgroup -
microsoft.public.sqlserver.integrationsvcs.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"TomT" <tomt (AT) newsgroup (DOT) nospam> wrote