I upgraded our SQL Server 2005 sp2 installation to SQL Server 2008. The
installation is a 32 bit install on a 64 bit Windows Server 2003 R2. The
install went fine but I am trying to open a DTS package using the designer
and immediately get the following message with no other message following
this:

TITLE: Object Explorer
------------------------------

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)

------------------------------
BUTTONS:

OK

I have the Client Tools Backward Compatibility (64-bit since the 32-bit msi
would not install) component installed as well as the above mentioned SQL
Server 2000 DTS Designer Components.

On my Vista workstation I am having the same problem since upgrading the
server to 2008.

Any help would be greatly appreciated.

--
TomM

Hello Tom,

This is Mark, a SQL Server Engineer. I'm glad to assist you with the issue.

In order to resolve the issue, I would like to explain the following:
A) SQL Server 2008 does not include support for the following DTS features:
1 There is no 64-bit design-time or run-time support for DTS packages.
On a 64-bit computer, DTS packages, and
Integration Services packages that run DTS packages, can run only
in 32-bit mode. To run DTS packages in 32-bit
mode, you have to install and use the 32-bit version of the dtexec
utility (dtexec.exe). To install the 32-bit version of the
dtexec utility, select Client Tools or Business Intelligence
Development Studio during setup.

2 There is also no 32-bit design-time or run-time support for DTS
packages on Itanium-based operating systems.
Therefore, you cannot create, view, modify, or run DTS packages on
Itanium-based operating systems.

B) To install the 32-bit version of the Integration Services runtime and
command prompt utilities on a 64-bit x86 computer
During Setup, select Business Intelligence Development Studio or Management
Tools - Complete. Selecting either of these options installs the 32-bit
version of of the Integration Services runtime, the dtexec utility
(dtexec.exe), and other Integration Services tools. There is an article to
share with you:http://msdn.microsoft.com/en-us/library/ms143755.aspx

C) How to: Run a Package Using the DTExec Utility, there is an article to
share with you:http://msdn.microsoft.com/en-us/libr...3(SQL.90).aspx

Besides, I do some addistional research for you: There is an article to
share with you:http://msdn.microsoft.com/en-us/library/ms162810.aspx

If you have any questions on the above information, please tell me.

Best regards,
Mark Han
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.
================================================== =======

Hello Tom,

This is Mark, a SQL Server Engineer. I'm glad to assist you with the issue.

In order to resolve the issue, I would like to explain the following:
A) SQL Server 2008 does not include support for the following DTS features:
1 There is no 64-bit design-time or run-time support for DTS packages.
On a 64-bit computer, DTS packages, and
Integration Services packages that run DTS packages, can run only
in 32-bit mode. To run DTS packages in 32-bit
mode, you have to install and use the 32-bit version of the dtexec
utility (dtexec.exe). To install the 32-bit version of the
dtexec utility, select Client Tools or Business Intelligence
Development Studio during setup.

2 There is also no 32-bit design-time or run-time support for DTS
packages on Itanium-based operating systems.
Therefore, you cannot create, view, modify, or run DTS packages on
Itanium-based operating systems.

B) To install the 32-bit version of the Integration Services runtime and
command prompt utilities on a 64-bit x86 computer
During Setup, select Business Intelligence Development Studio or Management
Tools - Complete. Selecting either of these options installs the 32-bit
version of of the Integration Services runtime, the dtexec utility
(dtexec.exe), and other Integration Services tools. There is an article to
share with you:http://msdn.microsoft.com/en-us/library/ms143755.aspx

C) How to: Run a Package Using the DTExec Utility, there is an article to
share with you:http://msdn.microsoft.com/en-us/libr...3(SQL.90).aspx

Besides, I do some addistional research for you: There is an article to
share with you:http://msdn.microsoft.com/en-us/library/ms162810.aspx

If you have any questions on the above information, please tell me.

Best regards,
Mark Han
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.
================================================== =======

Hello Tom,

This is Mark, a SQL Server Engineer. I'm glad to assist you with the issue.

In order to resolve the issue, I would like to explain the following:
A) SQL Server 2008 does not include support for the following DTS features:
1 There is no 64-bit design-time or run-time support for DTS packages.
On a 64-bit computer, DTS packages, and
Integration Services packages that run DTS packages, can run only
in 32-bit mode. To run DTS packages in 32-bit
mode, you have to install and use the 32-bit version of the dtexec
utility (dtexec.exe). To install the 32-bit version of the
dtexec utility, select Client Tools or Business Intelligence
Development Studio during setup.

2 There is also no 32-bit design-time or run-time support for DTS
packages on Itanium-based operating systems.
Therefore, you cannot create, view, modify, or run DTS packages on
Itanium-based operating systems.

B) To install the 32-bit version of the Integration Services runtime and
command prompt utilities on a 64-bit x86 computer
During Setup, select Business Intelligence Development Studio or Management
Tools - Complete. Selecting either of these options installs the 32-bit
version of of the Integration Services runtime, the dtexec utility
(dtexec.exe), and other Integration Services tools. There is an article to
share with you:http://msdn.microsoft.com/en-us/library/ms143755.aspx

C) How to: Run a Package Using the DTExec Utility, there is an article to
share with you:http://msdn.microsoft.com/en-us/libr...3(SQL.90).aspx

Besides, I do some addistional research for you: There is an article to
share with you:http://msdn.microsoft.com/en-us/library/ms162810.aspx

If you have any questions on the above information, please tell me.

Best regards,
Mark Han
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.
================================================== =======

Hello Tom,

This is Mark, a SQL Server Engineer. I'm glad to assist you with the issue.

In order to resolve the issue, I would like to explain the following:
A) SQL Server 2008 does not include support for the following DTS features:
1 There is no 64-bit design-time or run-time support for DTS packages.
On a 64-bit computer, DTS packages, and
Integration Services packages that run DTS packages, can run only
in 32-bit mode. To run DTS packages in 32-bit
mode, you have to install and use the 32-bit version of the dtexec
utility (dtexec.exe). To install the 32-bit version of the
dtexec utility, select Client Tools or Business Intelligence
Development Studio during setup.

2 There is also no 32-bit design-time or run-time support for DTS
packages on Itanium-based operating systems.
Therefore, you cannot create, view, modify, or run DTS packages on
Itanium-based operating systems.

B) To install the 32-bit version of the Integration Services runtime and
command prompt utilities on a 64-bit x86 computer
During Setup, select Business Intelligence Development Studio or Management
Tools - Complete. Selecting either of these options installs the 32-bit
version of of the Integration Services runtime, the dtexec utility
(dtexec.exe), and other Integration Services tools. There is an article to
share with you:http://msdn.microsoft.com/en-us/library/ms143755.aspx

C) How to: Run a Package Using the DTExec Utility, there is an article to
share with you:http://msdn.microsoft.com/en-us/libr...3(SQL.90).aspx

Besides, I do some addistional research for you: There is an article to
share with you:http://msdn.microsoft.com/en-us/library/ms162810.aspx

If you have any questions on the above information, please tell me.

Best regards,
Mark Han
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.
================================================== =======

Hello Tom,

This is Mark, a SQL Server Engineer. I'm glad to assist you with the issue.

In order to resolve the issue, I would like to explain the following:
A) SQL Server 2008 does not include support for the following DTS features:
1 There is no 64-bit design-time or run-time support for DTS packages.
On a 64-bit computer, DTS packages, and
Integration Services packages that run DTS packages, can run only
in 32-bit mode. To run DTS packages in 32-bit
mode, you have to install and use the 32-bit version of the dtexec
utility (dtexec.exe). To install the 32-bit version of the
dtexec utility, select Client Tools or Business Intelligence
Development Studio during setup.

2 There is also no 32-bit design-time or run-time support for DTS
packages on Itanium-based operating systems.
Therefore, you cannot create, view, modify, or run DTS packages on
Itanium-based operating systems.

B) To install the 32-bit version of the Integration Services runtime and
command prompt utilities on a 64-bit x86 computer
During Setup, select Business Intelligence Development Studio or Management
Tools - Complete. Selecting either of these options installs the 32-bit
version of of the Integration Services runtime, the dtexec utility
(dtexec.exe), and other Integration Services tools. There is an article to
share with you:http://msdn.microsoft.com/en-us/library/ms143755.aspx

C) How to: Run a Package Using the DTExec Utility, there is an article to
share with you:http://msdn.microsoft.com/en-us/libr...3(SQL.90).aspx

Besides, I do some addistional research for you: There is an article to
share with you:http://msdn.microsoft.com/en-us/library/ms162810.aspx

If you have any questions on the above information, please tell me.

Best regards,
Mark Han
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.
================================================== =======

Hello Tom,

This is Mark, a SQL Server Engineer. I'm glad to assist you with the issue.

In order to resolve the issue, I would like to explain the following:
A) SQL Server 2008 does not include support for the following DTS features:
1 There is no 64-bit design-time or run-time support for DTS packages.
On a 64-bit computer, DTS packages, and
Integration Services packages that run DTS packages, can run only
in 32-bit mode. To run DTS packages in 32-bit
mode, you have to install and use the 32-bit version of the dtexec
utility (dtexec.exe). To install the 32-bit version of the
dtexec utility, select Client Tools or Business Intelligence
Development Studio during setup.

2 There is also no 32-bit design-time or run-time support for DTS
packages on Itanium-based operating systems.
Therefore, you cannot create, view, modify, or run DTS packages on
Itanium-based operating systems.

B) To install the 32-bit version of the Integration Services runtime and
command prompt utilities on a 64-bit x86 computer
During Setup, select Business Intelligence Development Studio or Management
Tools - Complete. Selecting either of these options installs the 32-bit
version of of the Integration Services runtime, the dtexec utility
(dtexec.exe), and other Integration Services tools. There is an article to
share with you:http://msdn.microsoft.com/en-us/library/ms143755.aspx

C) How to: Run a Package Using the DTExec Utility, there is an article to
share with you:http://msdn.microsoft.com/en-us/libr...3(SQL.90).aspx

Besides, I do some addistional research for you: There is an article to
share with you:http://msdn.microsoft.com/en-us/library/ms162810.aspx

If you have any questions on the above information, please tell me.

Best regards,
Mark Han
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.
================================================== =======

Hello Tom,

This is Mark, a SQL Server Engineer. I'm glad to assist you with the issue.

In order to resolve the issue, I would like to explain the following:
A) SQL Server 2008 does not include support for the following DTS features:
1 There is no 64-bit design-time or run-time support for DTS packages.
On a 64-bit computer, DTS packages, and
Integration Services packages that run DTS packages, can run only
in 32-bit mode. To run DTS packages in 32-bit
mode, you have to install and use the 32-bit version of the dtexec
utility (dtexec.exe). To install the 32-bit version of the
dtexec utility, select Client Tools or Business Intelligence
Development Studio during setup.

2 There is also no 32-bit design-time or run-time support for DTS
packages on Itanium-based operating systems.
Therefore, you cannot create, view, modify, or run DTS packages on
Itanium-based operating systems.

B) To install the 32-bit version of the Integration Services runtime and
command prompt utilities on a 64-bit x86 computer
During Setup, select Business Intelligence Development Studio or Management
Tools - Complete. Selecting either of these options installs the 32-bit
version of of the Integration Services runtime, the dtexec utility
(dtexec.exe), and other Integration Services tools. There is an article to
share with you:http://msdn.microsoft.com/en-us/library/ms143755.aspx

C) How to: Run a Package Using the DTExec Utility, there is an article to
share with you:http://msdn.microsoft.com/en-us/libr...3(SQL.90).aspx

Besides, I do some addistional research for you: There is an article to
share with you:http://msdn.microsoft.com/en-us/library/ms162810.aspx

If you have any questions on the above information, please tell me.

Best regards,
Mark Han
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.
================================================== =======

Hello Tom,

This is Mark, a SQL Server Engineer. I'm glad to assist you with the issue.

In order to resolve the issue, I would like to explain the following:
A) SQL Server 2008 does not include support for the following DTS features:
1 There is no 64-bit design-time or run-time support for DTS packages.
On a 64-bit computer, DTS packages, and
Integration Services packages that run DTS packages, can run only
in 32-bit mode. To run DTS packages in 32-bit
mode, you have to install and use the 32-bit version of the dtexec
utility (dtexec.exe). To install the 32-bit version of the
dtexec utility, select Client Tools or Business Intelligence
Development Studio during setup.

2 There is also no 32-bit design-time or run-time support for DTS
packages on Itanium-based operating systems.
Therefore, you cannot create, view, modify, or run DTS packages on
Itanium-based operating systems.

B) To install the 32-bit version of the Integration Services runtime and
command prompt utilities on a 64-bit x86 computer
During Setup, select Business Intelligence Development Studio or Management
Tools - Complete. Selecting either of these options installs the 32-bit
version of of the Integration Services runtime, the dtexec utility
(dtexec.exe), and other Integration Services tools. There is an article to
share with you:http://msdn.microsoft.com/en-us/library/ms143755.aspx

C) How to: Run a Package Using the DTExec Utility, there is an article to
share with you:http://msdn.microsoft.com/en-us/libr...3(SQL.90).aspx

Besides, I do some addistional research for you: There is an article to
share with you:http://msdn.microsoft.com/en-us/library/ms162810.aspx

If you have any questions on the above information, please tell me.

Best regards,
Mark Han
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.
================================================== =======

Mark, thanks for the response but I have been through all of the mentioned
references already without success. Because I needed to get this done
relatively quickly I opened a support call to MS and am working with a tech
to resolve this as it has become quite complicated.

I will report our findings and resolution here when I have all of the
information.
--
TomM


"Mark Han[MSFT]" wrote: