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 |
|
cheechwan
Starting Member
11 Posts |
 Posted - 2006-08-16 : 04:23:40
|
| Dear Experts,HI, i have develop DTS Packages in SQL Server 2000, but i would like to migrate all these DTS packages to SQL Server 2005. I have saved all of the DTS Packages into this structure storage file format.Afterward, i move all these structure storage DTS Packages in SQL Server 2005.I use SQL Server Management Studio, Legacy-> Data Transformation Services to open the DTS Package. The system prompt me error message:SQL Server 2000 DTS Designer Components are required to edit DTS Packages: Install the special Web Download, "SQL Server 2000 DTS Designer Components" to use this feature. (Microsoft.SQLserver.DtsObjectExplorerUI)Do anyone know what are the issue? |
|
|
KenW
Constraint Violating Yak Guru
391 Posts |
Posted - 2006-08-16 : 14:45:55
|
cheechwan,quote:
Do anyone know what are the issue?
Yes. You need to install the special Web Download, "SQL Server 2000 DTS Designer Components" to use this feature.The message is telling you you need to go to the Microsoft website and download the above components.Ken |
 |
|
|
|
|
|
DTS Package Problem in SQL Server 2005