SQL 2000 DTS to SQL 2005

Hi

I currently have a DASP SQL Server 2000 Add on and am running DTS packages from my local computer using SQL Server 2000 enterprise. I am trying to upgrade to SQL Server 2005. My local computer has SQL 2005 EXPRESS and I don't see a way to run the SQL Server 2000 DTS packages in SQL Server 2005 EXPRESS on my local computer

Can anyone tell me if this is possible and if not how I can deal with this.

Thanks
albanello

 

Hi Tasslehoff

Thanks for your response.

As stated in my original post I am running SQL Server 2005 Express. Does this program you are talking about run as a stand alone everything I read says Express can not deal with DTS packages.

Also SQL 2000 Server is on one computer and SQL Server 2005 Express is on another computer if I run this program on the 2005 express computer how would I get the 2000 Server DTS packages to it, to work with them. Can I save them someplace else or is there a location I can copy and paste them to the 2005 express computer.

Sorry for the confusion, limites experiance, learning as I go

Thanks again
albanello

 

Hi Tasslehoff

Unfortunately I am not a student currently. The SQL Server 2000 Enterprise edition I have I got when I was a student some years ago. Currently I am trying to upgrade a web site I created while I was in school.

To buy a full blown version of SQL Server is to expensive for me at this time.

I will have to find a work around, maybe I could write a Stored Procedure that calls a SQL script I could call to download the information I need from my DASP SQL Server.

Is there some why in SQL server 2000 Enterprise edition to convert the DTS 2000 package to a SQL Script? If I could get that I could then use it to create a SQL Stored Procedure........I'm going to have to think about this.......I have been away from this for a couple years........ I'm trying to "Use it so I don't lose it"........

Thank for your response
albanello

 

...It will only cost you $50 on Amazon for the Developer edition of SQL Server.
The Developer edition has all of the features.

 

Hi wisemx

Thanks I did not know Developer was that inexpensive. Since I have to buy something should I just go all the way and migrate from SQL 2000 to SQL 2008 R2. I was doing 2005 because I thought that might be a easier migration step. Is there any pit falls to just go up to the newest SQL 2008 R2 from SQL 2000?

Thanks for you response
albanello

 

...From what I've tested 2008 R2 works well with the 2008 editions.
There are some things to be concerned about but they should all be addressed by now.
By that I mean any data feature differences.
For the most part I don't know of any but one thing that has been mentioned is the Reporting tools, other than that my own tests have been without any problems.

If you are uncertain I'd still go with SQL Server 2008, specially on the DASP side, you get more.

 

Hi wisemx

So if I am understanding you I should migrate from SQL 2000 to SQL 2008. There is no advantage/disadvantage to going to SQL 2005 first. Is that what you are suggesting ?

Thanks
albanello

 

...Yes you should.
You get more DB features, more space, it's better all around.
SQL Server 2000 was good in its day but that was a long time ago. ;-)

If you end up needing any help just re-post.

 

Thanks