Upgrading SQL Server 2000 DTS Packages to SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brian Knight » Upgrading SQL Server 2000 DTS Packages to...

16 posts, Page 1 of 2

1 2 »»

Upgrading SQL Server 2000 DTS Packages to SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

Brian Knight

Posted Monday, December 19, 2005 2:26 PM

SSCommitted

Group: Moderators
Last Login: Monday, August 13, 2012 1:06 PM
Points: 1,928, Visits: 224

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bknight/upgradingsqlserver2000dtspackagestossis.asp

Brian Knight
Free SQL Server Training Webinars

Post #245348

Dominique Danvoye

Posted Tuesday, December 27, 2005 7:38 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 02, 2007 4:47 AM
Points: 1, Visits: 1

I didn't know about the Package Designer for 2000, thanks.

Many article talk about upgrading but not a lot discuss a migration to a
completly new server. What about DTS in that case, would it be possible
to import it to 2005 from an actual 2000 system ?
If yes would it be possible to use it in the Package Designer?

Thanks for this precision,

Dominique.

Post #246706

Brian Knight

Posted Tuesday, December 27, 2005 9:29 AM

SSCommitted

Group: Moderators
Last Login: Monday, August 13, 2012 1:06 PM
Points: 1,928, Visits: 224

You bet, you can use the Upgrade Wizard to migrate the package to the SQL Server from a complely different server.

Brian Knight
Free SQL Server Training Webinars

Post #246739

Tony Proctor

Posted Friday, May 12, 2006 6:30 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, February 01, 2008 5:47 AM
Points: 1, Visits: 2

I'm afraid there's an element of naivety here. OK, a company may have "dozens or hundreds of SQL Server 2000 DTS packages", and - if they have enough budget - will eventually find time to re-write them. What about companies who sell DTS packages as part of their product suite? Not everyone is going to jump to SQL 2005 as soon as it's available and so those companies are obligated to continue support for both SQL 2000 and SQL 2005 within their customer base. This means they need increased resources to maintain parallel code streams, including the associated testing and documentation.

Maybe I'm missing something here: why couldn't Microsoft have provided a "DTS container" that would operate as a fully-fledged IS task but which could host an existing SQL 2000 DTS task. In other words, providing the necessary software interfaces and abstractions to allow a DTS task to run unchanged within IS.

Post #279571

jmetric

Posted Thursday, May 18, 2006 8:31 AM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, March 24, 2012 9:52 AM
Points: 1, Visits: 3

Is it possible to connect to a SQL 2005 server/instance from within a SQL 2000 DTS package?

Post #281096

Brian Knight

Posted Thursday, May 18, 2006 8:22 PM

SSCommitted

Group: Moderators
Last Login: Monday, August 13, 2012 1:06 PM
Points: 1,928, Visits: 224

I'm afraid it's not. It uses a different object model.

Brian Knight
Free SQL Server Training Webinars

Post #281287

P Jones

Posted Monday, September 04, 2006 7:22 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 1:58 AM
Points: 513, Visits: 1,014

I need that book NOW!!

So as I can't wait until January I'll just have to buy something else. Pity as I've already bought the reporting services and analysis services from that Professional SQL 2005 series.

Post #305984

Steve Jones - SSC Editor

Posted Monday, September 04, 2006 10:46 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 9:03 PM
Points: 31,406, Visits: 13,723

It's out now. This was a reprint from late last year.

You can get the book here: http://www.sqlservercentral.com/books/books.asp?categoryid=12&categorynm=SQL+Server+2005

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #306091

Francisco Lopez

Posted Friday, October 13, 2006 10:27 AM

SSC-Addicted

Group: General Forum Members
Last Login: Thursday, April 12, 2012 11:03 AM
Points: 455, Visits: 45

I am missing something here: I have several DTS 2000 packages nailing Sql 2005 server/instances databases.

It is worth adding that the feature pack may break Sql Server Enterprise Manager. You may have to re-install it to get it back to its original glory. Once you do this, though, you can work in both environments.

Also, when working with the DTS 2000 Package Designer (from Management Studio); you may not be able to alter any objects (edit anything) in Management Studio until the Package Designer is closed.

In my opinion, small pain with big gain. They were very nice to give us a DTS Designer for management Studio.

{Francisco}

Post #315341

Sorin Petcu

Posted Friday, February 01, 2008 5:09 AM

SSChasing Mays

Group: General Forum Members
Last Login: Monday, April 29, 2013 7:32 AM
Points: 620, Visits: 267

I 've used the Migration Wizard for my DTS packages and it was worked well. But, my new server and database server have different names from the old one. So I have to change the connections from inside every package. How to do that? How to edit the packages since they are already imported in SQL 2005 SSIS? I've tried with BI but there is no deploy option to deploy the package to SSIS repository where my packages are stand on.
Also, I have installed the DTS Designer 2000 but how to work with it in MSS Management Studio?

In Theory, theory and practice are the same...In practice, they are not.

Post #450403

« Prev Topic | Next Topic »

16 posts, Page 1 of 2

1 2 »»

Permissions