April 2, 2006 at 1:10 am
Hi Gurus,
There is a scenario, 2 servers with SQL 2000 version from server 1 to server 2 one DTS package is transferring data.
Now the server 1 SQL upgraded from 2000 to 2005 Yukon RTM. Now the case is, if you run the DTS in server 1, it is throwing an error like "Management Studio required " like (this is not exact err msg.).
What could be the possible reasons?
Do we want to upgrade the server 2 also 2005?
Thanks
Jay
http://www.sqldbops.com
April 2, 2006 at 11:19 am
How are you transferring the data? I suspect that some tasks may not work, but I'd think a simple data transfer will work.
April 2, 2006 at 11:52 am
Are you trying to open the dts packages in sql server management studio and its throwing an error? If so have you installed the Microsoft SQL Server 2000 DTS Designer Components which are required to open DTS packages in management studio if not go here and download and install them
If you are upgrading to sql server 2005 the tools in the business intelligence studio work pretty well for upgarding your DTS packages to SSIS ones but there are some packages it just cannot upgrade the only way to find out is test them first but I'm starting to apprecaite that SSIS is much better then DTS now that I'm getting used to it.
There is one bug which you may encounter when you deploy your packages to sql server 2005 and run them you basically get an error which says that the component you are trying to use is not licensed or something similar to overcome this install the SSIS server components on the workstation on which your are developing the packages and rebuild and redloy them and they'll work fine. This had me scratching my head for ages. THis apparently will be fixed in SP1 which is due around May i think.
Anyway I've upgraded some of our server to 2005 and a lot of the new features are great e.g. service broker, DDL triggers and the new error handling is great so I would advise anyone to upgrade though it maybe worth waiting a month or so for service pack 1 as there some silly bugs that are getting fixed in it.
hth
David
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply