February 3, 2011 at 7:46 am
Hi,
I am doing migration from SQL 2000 to SQL 2005 but on upgrade advisory i can see many below errors related to DTS package.
Error 1. Upgrade Advisor reports only on the most recent version of each DTS package</IssueDescription>
<IssueText>Upgrade Advisor reports only on the most recent version of each DTS package. To report on multiple versions of a DTS package, use the SSIS Package Migration Wizard, which is included with SQL Server 2005.
Error 2.SQL Server 2000 Data Transformation Services is deprecated</IssueDescription>
<IssueText>You must completely migrate existing SQL Server 2000 Data Transformation Services (DTS) packages to SQL Server 2005 Integration Services packages before support is withdrawn
Thanks in advance.
Error 3..Existing Meta Data Services packages should be moved to SQL Server storage (in the msdb database) or to structured storage files before you upgrade. SQL Server 2005 does not install support for SQL Server 2000 Meta Data Services; therefore the Package Migration Wizard will be unable to access Meta Data Services packages after upgrade in the absence of the SQL Server 2000 Client Tools.
Error 4.You can use SQL Server 2005 tools to edit your existing DTS packages. However, upgrading or uninstalling the last instance of SQL Server 2000 on a computer removes the components required to support this feature. You can retain or restore these components by installing the special Web download, "SQL Server 2000 DTS Designer Components", before or after you upgrade or uninstall SQL Server 2000.
Error 4. ODBC SQL Server Driver]Packet size change not honored by server, server size used
Error 5. ODBC SQL Server Driver]Packet size change not honored by server, server size used
Thanks in advance.
February 7, 2011 at 8:38 am
back when we did this what i did was create dummy databases on a test server with the same names as production. then saved all my DTS's there. and then saved them back to the new SQL 2005 server once we got it up and running
February 7, 2011 at 8:29 pm
Hi Alen,
Can you make me understand in detail ?
February 9, 2011 at 7:38 am
sql A is your source 2000 server
SQL B is the final 2005 server
test SQL is your temp server.
create empty databases on testSQL with the same names as on SQL A. open each DTS and save as on test SQL
after SQL B is set up and running do the same thing to save them on SQL B
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply