"Peter Yang [MSFT]" <petery@online.microsoft.com> wrote in message
news:QiRaK4B7GHA.3352@TK2MSFTNGXA01.phx.gbl...
> 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.
>

"Peter Yang [MSFT]" <petery@online.microsoft.com> wrote in message
news:4HNVAtQ7GHA.1860@TK2MSFTNGXA01.phx.gbl...
> Hello Laura,
>
> I was not able to reproduce the issue on my side. I have SQL 2005 sp1
> installed, I then installed DTS Designer Components and I can open DTS
> package saved from another SQL 2000 server properly.
>
> You may want to create a new simple package in Enterpise Manager on the
> same Win2003 machine, and save it to local folder, and try to open it via
> Management studio to see the result.
>
> If the issue still occurs, I suspect backup compatiblity component is not
> installed properly. You may want to repair backup compatiblity component
> as
> described in KB 919131 to see if it is helpful at this point. Or you may
> want to reinstall backup compatiblity component to test.
>
> Please let me know if there is any update. I look forward to your reply.
> Thank you!
>
> Best Regards,
>
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
>
> =====================================================
>
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> ======================================================
>
>

"Peter Yang [MSFT]" <petery@online.microsoft.com> wrote in message
news:KI4dEZP8GHA.4344@TK2MSFTNGXA01.phx.gbl...
> Hello Laura,
>
> Thank you for your reply. From the log I saw Sqlwb tried to load
> sqlgui.dll
> from C:\WINDOWS\system\ folder other than C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn folder.
>
>
> 1783 9:49:15 AM SqlWb.exe:2976 QUERY INFORMATION C:\Program
> Files\Microsoft
> SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SQLGUI.dll NOT FOUND
> Attributes: Error
> 1784 9:49:15 AM SqlWb.exe:2976 QUERY INFORMATION C:\Program
> Files\Microsoft
> SQL Server\90\Shared\SQLGUI.dll NOT FOUND Attributes: Error
> 1785 9:49:15 AM SqlWb.exe:2976 QUERY INFORMATION
> C:\WINDOWS\system32\SQLGUI.dll NOT FOUND Attributes: Error
> 1786 9:49:15 AM SqlWb.exe:2976 QUERY INFORMATION
> C:\WINDOWS\system\SQLGUI.dll SUCCESS Attributes: A
>
> 1794 9:49:15 AM SqlWb.exe:2976 READ C:\WINDOWS\system\SQLGUI.dll SUCCESS
> Offset: 0 Length: 256
> 1795 9:49:15 AM SqlWb.exe:2976 READ C:\WINDOWS\system\SQLGUI.dll SUCCESS
> Offset: 64 Length: 256
>
> I suggest that you temporarily remove the file from
> C:\WINDOWS\system\sqlgui.dll to another folder, and let sqlwb load than
> C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqlgui.dll to test the
> situation. It seems sqlwb tries to use the %path% variable to search for
> sqlgui.dll and it searches C:\WINDOWS\system\ before C:\Program
> Files\Microsoft SQL Server\80\Tools\Binn folder.
>
> In addition, the file version of C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqlgui.dll shall be 2000.80.2039 for sp1.
>
> If you have any update, please feel free to let's know. Thank you for your
> time.
>
> Best Regards,
>
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
>
>
> =====================================================
>
> PLEASE NOTE: The partner managed newsgroups are provided to assist with
> break/fix
> issues and simple how to questions.
>
> We also love to hear your product feedback!
>
> Let us know what you think by posting
> - from the web interface: Partner Feedback
> - from your newsreader: microsoft.private.directaccess.partnerfeedback.
> We look forward to hearing from you!
> ======================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> ======================================================
>
>