Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

I just got my first chance to install SQL Server 2012 on a test machine. I also installed all of the management and Visual Studios components. I created a copy of one of my SSIS 2008 packages and converted it to 2012. The conversion worked jsut fine, but I'm now getting an error stating that connections to SQL Server 2000 and earlier versions are no longer supported.

Is there a workaround for this? Is there another way to create a connection to a 2000 database? We're not currently in a place to move this database off of 2000.

The connection is currently set up as an OLE DB connection for a couple of data sources.

share|improve this question
I don't have enough reputation yet to post comments, so I guess I'll have to post here: Could you maybe create an ODBC DSN to the server / database and use that instead of OLE DB? – Levi W Jun 13 '12 at 15:27
What connection manager (ole, odbc, ado) are you using to talk to the SQL 2000 instance? Is it being used as a source, destination, lookup, something-else? – billinkc Jun 18 '12 at 17:40
@billinkc added info – DForck42 Jun 18 '12 at 18:17

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.