Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vyelchri
Starting Member
12 Posts |
 Posted - 2009-06-18 : 07:43:16
|
| HI,we are migrating SQL Server 2000 to SQL Server 2005. we have some DTS packages created in 2000 server. we want to migrate SQL Server 2000 DTS packages to 2005 SSIS packages.I came to know with three methods for migrating process. Can somebody suggest what is the best method to migrate the DTS packages to SSIS packages?1. Using SQL Server 2005 upgrade adviser 2. Redesiging the new SSIS packages with same functionality of DTS 3. Using migration wizards from BIDS(Businees Intelligence Development Studio)Thanks,VB |
|
|
vyelchri
Starting Member
12 Posts |
Posted - 2009-06-23 : 01:23:44
|
| I downloaded SQL Server 2005 upgrade advisor and installed on my machine. when i trying to access the "Launch Upgrade Advisor Analysis Wizard" it is giving some error message if given instance name. Following is the error message i got:SQL Server version: 09.00.3073 is not supported by this release of Upgrade Advisor.Can some body plz assist me to resolve this issue?Thanks,VB |
 |
|
|
|
|
|
Upgrading DTS packages to SSIS packages