SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Upgrading SQL Server 2000 DTS Packages to SSIS


Upgrading SQL Server 2000 DTS Packages to SSIS

Author
Message
Brian Knight
Brian Knight
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: Moderators
Points: 5241 Visits: 235
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
Dominique Danvoye
Dominique Danvoye
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 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.
Brian Knight
Brian Knight
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: Moderators
Points: 5241 Visits: 235

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
Tony Proctor
Tony Proctor
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 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.

jmetric
jmetric
SSC Rookie
SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)

Group: General Forum Members
Points: 31 Visits: 3

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





Brian Knight
Brian Knight
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: Moderators
Points: 5241 Visits: 235
I'm afraid it's not. It uses a different object model.

Brian Knight
Free SQL Server Training Webinars
P Jones
P Jones
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2782 Visits: 1524

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.


Steve Jones
Steve Jones
SSC Guru
SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)SSC Guru (143K reputation)

Group: Administrators
Points: 143626 Visits: 19424
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
My Blog: www.voiceofthedba.com
Francisco Lopez
Francisco Lopez
Say Hey Kid
Say Hey Kid (663 reputation)Say Hey Kid (663 reputation)Say Hey Kid (663 reputation)Say Hey Kid (663 reputation)Say Hey Kid (663 reputation)Say Hey Kid (663 reputation)Say Hey Kid (663 reputation)Say Hey Kid (663 reputation)

Group: General Forum Members
Points: 663 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}
Sorin Petcu
Sorin Petcu
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1351 Visits: 367
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search