Hi all

I just ran sql upgrade advisor and got the following message:

"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,� from the Microsoft
Download Center
before or after you upgrade or uninstall SQL Server 2000."



I do have several DTS packages in my sql server 2000 database. does that
mean if I upgrade my current 2000 database to 2005, those dts will be gone.
But I can download sql server 2000 dts deginer components on our new sql 2005
database server before I upgrade. Then when I restore my sql 2000 database on
our new 2005 server, eveything would be OK? I am not sure if my understanding
is correct.



My advisor is on my local computer and I am running analysis against a
remote database(on our intranet),“SQL Server 2000 DTS Designer Components,�
should be intalled on my local computer or remote database server? what steps
I should take in order to retain my dts package or transform it into
something else?



can you shed light on me?


--
Betty

Hi Betty,
Regarding your questions, please see the answers inline.

You can backup your databases in your SQL Server 2000 and then restore them
in SQL Server 2005; however you could not restore your DTS packages same as
restoring your databases since DTS packages are not stored in your user
databases. Regarding move DTS packages, please refer to this KB article:
How to move databases between computers that are running SQL Server
http://support.microsoft.com/?id=314546

You need to install your SQL Server 2000 DTS Designer Components on your
remote SQL Server 2005 database server.
Though you can use SQL Server 2000 DTS packages in SQL Server 2005 by
installing SQL Server 2000 DTS Designer Components, I would like to let you
know that in SQL Server 2005 DTS has been replaced by SQL Server
Integration Services (SSIS). In SQL Server 2005, it is recommended that you
create SSIS packages for future use. You may want the following reference:
http://www.microsoft.com/sql/technol...ion/tours.mspx
MSDN TV: Building SQL Server Integration Services Packages
http://www.microsoft.com/downloads/d...631-F196-4B00-
9320-DEC1FDA8BB0C&displaylang=en

If you have any other questions or concerns, please feel free to let me
know. Have a nice day!


Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Betty,
Regarding your questions, please see the answers inline.

You can backup your databases in your SQL Server 2000 and then restore them
in SQL Server 2005; however you could not restore your DTS packages same as
restoring your databases since DTS packages are not stored in your user
databases. Regarding move DTS packages, please refer to this KB article:
How to move databases between computers that are running SQL Server
http://support.microsoft.com/?id=314546

You need to install your SQL Server 2000 DTS Designer Components on your
remote SQL Server 2005 database server.
Though you can use SQL Server 2000 DTS packages in SQL Server 2005 by
installing SQL Server 2000 DTS Designer Components, I would like to let you
know that in SQL Server 2005 DTS has been replaced by SQL Server
Integration Services (SSIS). In SQL Server 2005, it is recommended that you
create SSIS packages for future use. You may want the following reference:
http://www.microsoft.com/sql/technol...ion/tours.mspx
MSDN TV: Building SQL Server Integration Services Packages
http://www.microsoft.com/downloads/d...631-F196-4B00-
9320-DEC1FDA8BB0C&displaylang=en

If you have any other questions or concerns, please feel free to let me
know. Have a nice day!


Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Betty,
Regarding your questions, please see the answers inline.

You can backup your databases in your SQL Server 2000 and then restore them
in SQL Server 2005; however you could not restore your DTS packages same as
restoring your databases since DTS packages are not stored in your user
databases. Regarding move DTS packages, please refer to this KB article:
How to move databases between computers that are running SQL Server
http://support.microsoft.com/?id=314546

You need to install your SQL Server 2000 DTS Designer Components on your
remote SQL Server 2005 database server.
Though you can use SQL Server 2000 DTS packages in SQL Server 2005 by
installing SQL Server 2000 DTS Designer Components, I would like to let you
know that in SQL Server 2005 DTS has been replaced by SQL Server
Integration Services (SSIS). In SQL Server 2005, it is recommended that you
create SSIS packages for future use. You may want the following reference:
http://www.microsoft.com/sql/technol...ion/tours.mspx
MSDN TV: Building SQL Server Integration Services Packages
http://www.microsoft.com/downloads/d...631-F196-4B00-
9320-DEC1FDA8BB0C&displaylang=en

If you have any other questions or concerns, please feel free to let me
know. Have a nice day!


Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Betty,
Regarding your questions, please see the answers inline.

You can backup your databases in your SQL Server 2000 and then restore them
in SQL Server 2005; however you could not restore your DTS packages same as
restoring your databases since DTS packages are not stored in your user
databases. Regarding move DTS packages, please refer to this KB article:
How to move databases between computers that are running SQL Server
http://support.microsoft.com/?id=314546

You need to install your SQL Server 2000 DTS Designer Components on your
remote SQL Server 2005 database server.
Though you can use SQL Server 2000 DTS packages in SQL Server 2005 by
installing SQL Server 2000 DTS Designer Components, I would like to let you
know that in SQL Server 2005 DTS has been replaced by SQL Server
Integration Services (SSIS). In SQL Server 2005, it is recommended that you
create SSIS packages for future use. You may want the following reference:
http://www.microsoft.com/sql/technol...ion/tours.mspx
MSDN TV: Building SQL Server Integration Services Packages
http://www.microsoft.com/downloads/d...631-F196-4B00-
9320-DEC1FDA8BB0C&displaylang=en

If you have any other questions or concerns, please feel free to let me
know. Have a nice day!


Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Betty,
Regarding your questions, please see the answers inline.

You can backup your databases in your SQL Server 2000 and then restore them
in SQL Server 2005; however you could not restore your DTS packages same as
restoring your databases since DTS packages are not stored in your user
databases. Regarding move DTS packages, please refer to this KB article:
How to move databases between computers that are running SQL Server
http://support.microsoft.com/?id=314546

You need to install your SQL Server 2000 DTS Designer Components on your
remote SQL Server 2005 database server.
Though you can use SQL Server 2000 DTS packages in SQL Server 2005 by
installing SQL Server 2000 DTS Designer Components, I would like to let you
know that in SQL Server 2005 DTS has been replaced by SQL Server
Integration Services (SSIS). In SQL Server 2005, it is recommended that you
create SSIS packages for future use. You may want the following reference:
http://www.microsoft.com/sql/technol...ion/tours.mspx
MSDN TV: Building SQL Server Integration Services Packages
http://www.microsoft.com/downloads/d...631-F196-4B00-
9320-DEC1FDA8BB0C&displaylang=en

If you have any other questions or concerns, please feel free to let me
know. Have a nice day!


Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Betty,
Regarding your questions, please see the answers inline.

You can backup your databases in your SQL Server 2000 and then restore them
in SQL Server 2005; however you could not restore your DTS packages same as
restoring your databases since DTS packages are not stored in your user
databases. Regarding move DTS packages, please refer to this KB article:
How to move databases between computers that are running SQL Server
http://support.microsoft.com/?id=314546

You need to install your SQL Server 2000 DTS Designer Components on your
remote SQL Server 2005 database server.
Though you can use SQL Server 2000 DTS packages in SQL Server 2005 by
installing SQL Server 2000 DTS Designer Components, I would like to let you
know that in SQL Server 2005 DTS has been replaced by SQL Server
Integration Services (SSIS). In SQL Server 2005, it is recommended that you
create SSIS packages for future use. You may want the following reference:
http://www.microsoft.com/sql/technol...ion/tours.mspx
MSDN TV: Building SQL Server Integration Services Packages
http://www.microsoft.com/downloads/d...631-F196-4B00-
9320-DEC1FDA8BB0C&displaylang=en

If you have any other questions or concerns, please feel free to let me
know. Have a nice day!


Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Betty,
Regarding your questions, please see the answers inline.

You can backup your databases in your SQL Server 2000 and then restore them
in SQL Server 2005; however you could not restore your DTS packages same as
restoring your databases since DTS packages are not stored in your user
databases. Regarding move DTS packages, please refer to this KB article:
How to move databases between computers that are running SQL Server
http://support.microsoft.com/?id=314546

You need to install your SQL Server 2000 DTS Designer Components on your
remote SQL Server 2005 database server.
Though you can use SQL Server 2000 DTS packages in SQL Server 2005 by
installing SQL Server 2000 DTS Designer Components, I would like to let you
know that in SQL Server 2005 DTS has been replaced by SQL Server
Integration Services (SSIS). In SQL Server 2005, it is recommended that you
create SSIS packages for future use. You may want the following reference:
http://www.microsoft.com/sql/technol...ion/tours.mspx
MSDN TV: Building SQL Server Integration Services Packages
http://www.microsoft.com/downloads/d...631-F196-4B00-
9320-DEC1FDA8BB0C&displaylang=en

If you have any other questions or concerns, please feel free to let me
know. Have a nice day!


Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Betty,
Regarding your questions, please see the answers inline.

You can backup your databases in your SQL Server 2000 and then restore them
in SQL Server 2005; however you could not restore your DTS packages same as
restoring your databases since DTS packages are not stored in your user
databases. Regarding move DTS packages, please refer to this KB article:
How to move databases between computers that are running SQL Server
http://support.microsoft.com/?id=314546

You need to install your SQL Server 2000 DTS Designer Components on your
remote SQL Server 2005 database server.
Though you can use SQL Server 2000 DTS packages in SQL Server 2005 by
installing SQL Server 2000 DTS Designer Components, I would like to let you
know that in SQL Server 2005 DTS has been replaced by SQL Server
Integration Services (SSIS). In SQL Server 2005, it is recommended that you
create SSIS packages for future use. You may want the following reference:
http://www.microsoft.com/sql/technol...ion/tours.mspx
MSDN TV: Building SQL Server Integration Services Packages
http://www.microsoft.com/downloads/d...631-F196-4B00-
9320-DEC1FDA8BB0C&displaylang=en

If you have any other questions or concerns, please feel free to let me
know. Have a nice day!


Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Charles,
thanks for your instruction. I decided to try to Building SQL Server
Integration Services Packages. can you give detailed instructions for using
Business Intelligence Developement.
I have Microsoft Visual Studio Professional version installed.

Thanks
--
Betty


"Charles Wang[MSFT]" wrote: