Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Upgrading SQL Server 2000 DTS Packages to SSIS Expand / Collapse
Author
Message
Posted Monday, December 19, 2005 2:26 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234
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
Posted Tuesday, December 27, 2005 7:38 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 2, 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
Posted Tuesday, December 27, 2005 9:29 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234

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
Posted Friday, May 12, 2006 6:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 1, 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
Posted Thursday, May 18, 2006 8:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, May 18, 2006 8:22 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Wednesday, June 4, 2014 12:29 PM
Points: 1,931, Visits: 234
I'm afraid it's not. It uses a different object model.

Brian Knight
Free SQL Server Training Webinars
Post #281287
Posted Monday, September 4, 2006 7:22 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 1:51 AM
Points: 579, Visits: 1,255

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
Posted Monday, September 4, 2006 10:46 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:11 PM
Points: 31,368, Visits: 15,837
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
Posted Friday, October 13, 2006 10:27 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-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
Posted Friday, February 1, 2008 5:09 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, September 19, 2014 12:29 AM
Points: 622, Visits: 287
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 »

Add to briefcase 12»»

Permissions Expand / Collapse