DTS Designer error

when I open a DTS package (or create a new one) I get the error:
DTS Designer error
The system cannot find the file specified
then the package opens, but there are no objects in the "tasks" pane (the
"connection" pane looks ok). All the task objects in the package show up
though (and can be edited too) but no new ones can be added (since also under
the Task menu, only the items "Register custom task..." and "Unregister
custom task..." exist).
So the question is: which dlls are the missing tasks so that to register
them back?
Also, any ideas why they dissapeared?
It's generally from having a mix of different service pack
levels. See the following article:
Service Pack and Version Compatibility Problems
http://www.sqldts.com/default.aspx?223
-Sue
On Wed, 25 Jan 2006 02:13:02 -0800, "vsiat"
<vsiat@.discussions.microsoft.com> wrote:

>when I open a DTS package (or create a new one) I get the error:
>DTS Designer error
>The system cannot find the file specified
>then the package opens, but there are no objects in the "tasks" pane (the
>"connection" pane looks ok). All the task objects in the package show up
>though (and can be edited too) but no new ones can be added (since also under
>the Task menu, only the items "Register custom task..." and "Unregister
>custom task..." exist).
>So the question is: which dlls are the missing tasks so that to register
>them back?
>Also, any ideas why they dissapeared?
|||It didnt work. I checked both
http://www.sqldts.com/default.aspx?223 and the related link
http://support.microsoft.com/Default.aspx?kbid=274716
but they all seem to refer to SQL Server 7.0 issues.
I have SQL 2000 SP4 (both on the server and the client tools in my pc) and
the packages were created with this version.
"Sue Hoegemeier" wrote:

> It's generally from having a mix of different service pack
> levels. See the following article:
> Service Pack and Version Compatibility Problems
> http://www.sqldts.com/default.aspx?223
> -Sue
>
|||Try opening the packages from another box. If you can open
them fine on other boxes then it's specific to that box. You
could first try reregistering dtsui.dll. Other than that,
they rest are listed in the following:
http://www.sqldts.com/default.aspx?225
-Sue
On Thu, 26 Jan 2006 03:31:02 -0800, "vsiat"
<vsiat@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>It didnt work. I checked both
>http://www.sqldts.com/default.aspx?223 and the related link
>http://support.microsoft.com/Default.aspx?kbid=274716
>but they all seem to refer to SQL Server 7.0 issues.
>I have SQL 2000 SP4 (both on the server and the client tools in my pc) and
>the packages were created with this version.
>
>"Sue Hoegemeier" wrote:
|||Oh yes, I forgot to mention that: The problem is ONLY on my pc. When I open
the packages from the Enterprise Manager on the server, or any other pc with
the client tools, everything is ok.
The dlls listed in the link (and also the ones in the redistr.txt of SP4)
are not the missing tools of the DTS Designer, they seem to only contain
supporting code to run DTS packages from other applications (including the EM
itself). I register them, but nothing changes on the interface.
I have also re-installed the client tools and re-applied SP4, but still
nothing.
"Sue Hoegemeier" wrote:

> Try opening the packages from another box. If you can open
> them fine on other boxes then it's specific to that box. You
> could first try reregistering dtsui.dll. Other than that,
> they rest are listed in the following:
> http://www.sqldts.com/default.aspx?225
> -Sue
|||Additionally, here are some other people with the same problem (none got any
lucky):
http://groups.google.com/group/micro...0e3c34fa5a0 9
http://groups.google.com/group/micro...d930f85a8ba 3
http://groups.google.com/group/micro...40731b4429b a
|||I know others have reported similar issues.
I believe Dtsui has the icons.
Only other thing I can think of to try is reapplying the
last service pack on your PC.
-Sue
On Fri, 27 Jan 2006 01:16:02 -0800, "vsiat"
<vsiat@.discussions.microsoft.com> wrote:

>Additionally, here are some other people with the same problem (none got any
>lucky):
>http://groups.google.com/group/micro...0e3c34fa5a0 9
>http://groups.google.com/group/micro...d930f85a8ba 3
>http://groups.google.com/group/micro...40731b4429b a
|||I'm having this issue but slightly different situation. When I create a new DTS package or edit an existing package I get a messagebox "DTS Designer Error" with text "Access is denied." The twist is that this only happens to me when I log in to windows as a user joined to a domain. When I log in to windows as the local administrator everything works correctly.
Obviously it has to do with permissions, but whats odd is that I have added the domain user to the (local) Administrators group specifically to *have* unrestricted rights to my machine. Somehow, in this particular instance, it seems EM is attempting to list the DTS tasks installed in a way that windows,domain security,group policies are disallowing.
AFAIK, the dts tasks are enumerated in the registry. So I don't understand how file permissions could play a role.sql