RE: Edit SQL 2000 DTS package from SQL 2005

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hello,

I understand that you cannot edit SQL 2000 DTS packages from mangement
studio on some machines. To know the issue better, I'd like to know the
following information:

1. Do you have SQL 2005 Backward Compatibility Components installed on the
problemtic machines? Or you only installed 2005 feature package which
includes Microsoft SQL Server 2000 DTS Designer Components?

905417 FIX: Error message when you try to open SQL Server 2000 Data
Transformation Services (DTS) packages in SQL Server Management Studio:
"SQL Server 2000 DTS Designer components are required to edit DTS packages"
http://support.microsoft.com/default.aspx?scid=kb;EN-US;905417

2. Did you have SSIS installed on the machines having this issue?


3. Did you check if the folder c:\Program Files\Microsoft SQL
Server\80\Tools\Binn exist and the following registry key exist?

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\80\Tools\ClientSetup

By default, Support for SQL Server 2000 DTS is installed automatically when
you install SQL Server 2005 Integration Services. However, some of the
registry settings and some of the environment settings that SQL Server 2000
DTS requires are deleted when you upgrade the last instance of SQL Server
2000. You may want to use the method4 in the following article to fix the
issue if the registry key is not correct:

919131 You may experience problems when you try to run a SQL Server 2000
DTS package after you upgrade all the instances of SQL Server 2000 to SQL
Server 2005
http://support.microsoft.com/default.aspx?scid=kb;EN-US;919131


Also, if you have 2005 sp1 installed, you may want to install latest
feature pack to see if it helps:

Feature Pack for Microsoft SQL Server 2005 - April 2006
http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-
aa0a-b477ba72a9cb&DisplayLang=en


In addtion, as I know, the SQL 2000 DTS Designer Components are not
supported on workstations with both 2000 and 2005 clients. The reason is
that the add-on was only designed to be loaded with SQL 2005 client tools,
not with SQL 2000 tools. You may encounter issues when saving DTS pacakge
in 2005 when you have both 2005 and 2000 client tools installed. The
workaround as I know is to save the package using menu Package --> Save,
then close using "X" on the right hand side.


If you have any update on the issue, please feel free to let me know. Thank
you!

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
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/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • Re: SSIS as part of scheduled job fails
    ... Can't even open the package. ... Microsoft SQL Server Management Studio ... Encryption not supported on SQL Server. ...
    (microsoft.public.sqlserver.dts)
  • Re: Problems launching DTS package from Stored Procedure
    ... >I have a stored procedure create for the sole purpose of launching a DTS ... I can post the SQL later if necessary. ... >package name as a parameter, executes the package and continues on. ... a query to retrieve the data and a connection to SQL Server. ...
    (microsoft.public.sqlserver.dts)
  • Re: Saving DTS Packages
    ... There is from within the Designer a way to save a package out as a VB .bas ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ...
    (microsoft.public.sqlserver.dts)
  • Re: Error when running SQL 2000 dts Package in SQL Server 2005
    ... Lotus SQL Driver works fine. ... created a package in SQL 2000 and trying to call it in SQL 2005'S Legacy Data ... I am able to create a new table using this DTS ... OK so if this fails when you use the package in an Execute DTS 2000 Package ...
    (microsoft.public.sqlserver.dts)
  • Re: SSIS as part of scheduled job fails
    ... I noticed that you are currently working with Matt and I'd like to know how ... Can't even open the package. ... Microsoft SQL Server Management Studio ...
    (microsoft.public.sqlserver.dts)