Re: Blank DTS Packages - recovers with reboot

Hello lowrykoz,

I can honestly say I have never seen this. I am a little confused as to your service packing as well. Is SQL Server on SP1?



--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

I have an odd problem I have been assigned to debug and am having no
luck finding anything online that is even close. Maybe someone else
has had this issue. We have a windows 2000 box on sp 1 with Windows
2000 sp 4.

One of our developers discovered that every 3 weeks or so his dts
packages are completely empty, no prior versions or anything. The jobs
run successfully in one second(nothing to fail) instead of the normal
2 - 3 minute run time. Rebooting the system brings the packages back.
Extremely odd!! Does anyone have any clues on where I can go to debug
this? Nothing unusual shows up in the sql error logs or the server
event logs

This is the senior developer's notes "The issue was that all DTS
packages on the server got “blanked out.” Meaning, if you opened up
Enterprise Manager on the server and then went to edit any DTS
package… the DTS package designer was empty.

The scheduled packages were still running, but they would report
success for every run, and the run time was only 1 second. (Of course…
it only takes 1 second to run a blank DTS package… and there is no
failure if nothing is run!).

The cause is unknown. The ‘fix’ is a restart. The frequency is about
once every couple of weeks. The symptoms are, nothing transferring (0
campaigns) and that the DTS packages are reporting a 1 second time
instead of the average 2-3 minutes to run."

Any and all help is greatly appreciated



.

Relevant Pages

  • Re: SQL server 2005 & DTS from SQL 2000
    ... As the DTS packages that i need to transfer into the server will also need ... We installed the Legacy Components with our SQL Server 2005 installs. ...
    (microsoft.public.sqlserver.dts)
  • Re: Editing DTS Packages on a 64-bit SQL Server 2005 installation
    ... The tips for running 32-SSIS packages can be extended to running 32-bit DTS ... store your DTS packages in a 64-bit SQL Server database. ... have tried installing the Web download it says to install but then I get ...
    (microsoft.public.sqlserver.setup)
  • Re: Upgrading DTS to SSIS
    ... You cannot run packages outside of BI Development Studio on a client computer that does not have Integration Services installed, and the terms of your SQL Server 2005 licensing may not permit you to install Integration Services on additional computers. ... SQL Server 2005 Integration Services (SSIS) is now a server component and is not redistributable to client computers in the same manner that the components required for SQL Server 2000 Data Transformation Services (DTS) were redistributable. ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL 2000 - Connection Error with DTS Packages
    ... After I changed all SQL Server 'Database Connection' steps in each of my ... did the "Schedule Package" option when you right click a DTS package name ... What I had been using to run the DTS package in the job step was: ...
    (microsoft.public.sqlserver.dts)
  • RE: DTS Sucess but fails to go to next step when scheduled
    ... odbc connection to an Oracle database in my dts packages. ... My particular situation involves pulling data from an Oracle 9database into ... SQL Server 2000 -- when the Oracle database was in 8i it worked much faster ...
    (microsoft.public.sqlserver.dts)