February 21, 2009 at 10:04 pm
Hello,
We are upgrading from sql server 2000 to sql server 2005.We have only 2 DTS packages and following the following method which is described in http://blogs.msdn.com/psssql/archive/2009/02/19/how-to-copy-dts-2000-packages-between-servers-and-from-sql-2000-to-sql-2005-and-sql-2008.aspx.
METHOD 1B. Save to structured storage files, and copy those files to SQL 2005, and import into Legacy 2000 Packages one at a time.
+ In the Save DTS Package dialogue, save to location "Structured Storage File"
+ Provide a location and name for the .dts file.
+ Copy the file to a location accessible to the SQL 2005 Server
+ Find the Data Transformation Services icon in Object explorer in 2005. (Object Explorer connected to SQL Database Engine, under the Server name > Management > Legacy > Data Transformation Services)
+ Right click > "Import Package File..." and point to the structured storage file.
We are succesfully moved to sql 2005 by using this method.We have Active Script task, Dynamic properties task and execute sql task and text file source.
After moving to sql 2005, in above tasks what should I do inoder to work the DTS package correctly?as in sql 2000. Its a side by side upgrade and sql server 2005 is a new server.
February 22, 2009 at 4:11 am
you could import as legacy but if moving to sql2005 why not re write the package in SSIS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
February 22, 2009 at 10:32 am
Thanks,
We will convert the DTS to SSIS later but right now we are going with the same dts to run in sql 2005.
We are succesfully moved to sql 2005 by using this method.We have Active Script task, Dynamic properties task and execute sql task and text file source.
After moving to sql 2005, in above tasks what should I do inoder to work the DTS package correctly?as in sql 2000. Its a side by side upgrade and sql server 2005 is a new server
Plz tell me what I have to do here?
February 22, 2009 at 10:46 am
did you download and install the backward compatibility DTS designer tool?
all you should need to do is possibly amend connection strings if they refer to the old server by name, and then reschedule the jobs in SQLAgent if they were previously run from there.
---------------------------------------------------------------------
February 22, 2009 at 2:34 pm
You may try BIDS (Business Intelligence Development Studio).
February 23, 2009 at 9:22 am
SQL ORACLE (2/22/2009)
You may try BIDS (Business Intelligence Development Studio).
That won't help him if he wants to to keep the packages as legacy DTS. I second George's advice. The tasks in the packages will work as long as they remain DTS packages.
Greg
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply