|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
DTS Designer errorwhen 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" <vs***@discussions.microsoft.com> wrote: Show quote >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. Show quote "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" <vs***@discussions.microsoft.com> wrote: Show quote >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 >> 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. Show quote "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/microsoft.public.sqlserver.dts/browse_thread/thread/bf69c20d43d59c07/9d820e3c34fa5a09?lnk=st&q=designer+error+the+system+cannot+find+the+file+specified+group%3Amicrosoft.public.sqlserver.dts&rnum=1&hl=en#9d820e3c34fa5a09 http://groups.google.com/group/microsoft.public.sqlserver.dts/browse_thread/thread/f49219897ee34843/0e1bd930f85a8ba3?lnk=st&q=designer+error+the+system+cannot+find+the+file+specified+group%3Amicrosoft.public.sqlserver.dts&rnum=2&hl=en#0e1bd930f85a8ba3 http://groups.google.com/group/microsoft.public.sqlserver.dts/browse_thread/thread/519738b392925208/b4ff40731b4429ba?lnk=st&q=designer+error+the+system+cannot+find+the+file+specified+group%3Amicrosoft.public.sqlserver.dts&rnum=8&hl=en#b4ff40731b4429ba 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" <vs***@discussions.microsoft.com> wrote: Show quote >Additionally, here are some other people with the same problem (none got any >lucky): > >http://groups.google.com/group/microsoft.public.sqlserver.dts/browse_thread/thread/bf69c20d43d59c07/9d820e3c34fa5a09?lnk=st&q=designer+error+the+system+cannot+find+the+file+specified+group%3Amicrosoft.public.sqlserver.dts&rnum=1&hl=en#9d820e3c34fa5a09 > >http://groups.google.com/group/microsoft.public.sqlserver.dts/browse_thread/thread/f49219897ee34843/0e1bd930f85a8ba3?lnk=st&q=designer+error+the+system+cannot+find+the+file+specified+group%3Amicrosoft.public.sqlserver.dts&rnum=2&hl=en#0e1bd930f85a8ba3 > >http://groups.google.com/group/microsoft.public.sqlserver.dts/browse_thread/thread/519738b392925208/b4ff40731b4429ba?lnk=st&q=designer+error+the+system+cannot+find+the+file+specified+group%3Amicrosoft.public.sqlserver.dts&rnum=8&hl=en#b4ff40731b4429ba  |
|||||||||||||||||||||||
Other interesting topics