Re: Migrating DTS Local Package from test to production environments v7.0

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ted (myitpro_at_att.net)
Date: 02/26/04 

Date: Thu, 26 Feb 2004 08:47:58 -0600

Thank you Ross and Allan for your suggestions.

When I got to the client, the DTS package was working! Well, it was working
if launched from the DTS Designer window, but would not launch from the
Scheduler.

This is a SQL Server 7.0 installation. I don't know what SP level they are
at.

The original error they were getting was:
Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description: Invalid class string.

A search for this error message turned up the MSDN Q288910. The only
applicable parts of the error cause and solution was (no OLAP and not Server
2000):

Cause:
A package includes a user-designed custom DTS task but the workstation on
which the package is opened does not have this task registered.

Solution:
If your package contains custom DTS tasks, you must register these tasks on
the workstation in question.

There are no instructions on how to do the suggested solution.

The client had rebooted the server a couple times, but this did not change
the error. The next morning, when I came in, the error was not being
repeated.

So, the situation is that the client can manually run the DTS package each
morning, but it will not run from the scheduler. They get a "failed"
message.

Not much to go on and the client is willing to "work it out themselves for
now," but I'm curious for my own sake. Any ideas what is causing the DTS to
work manually but not from the SQL scheduler?

Thanks a lot.

Ted

Relevant Pages

  • Re: Export more than 65536 records from ADP to excel 2007
    ... But you can also download from MS a free DTS runtime package that lets you run a DTS package on the client. ... I had hoped to be able to export to excel 2007 from an adodb.recordset ...
    (microsoft.public.access.adp.sqlserver)
  • Re: DTS Process Cube Task
    ... It has a command-line interface -- so you would use a DTS Process Task ... private dimension that contained more than 2 million members. ... occasionally the cube would process, and that was throwing me off. ... DTSRUN of the package from the command-line. ...
    (microsoft.public.sqlserver.olap)
  • Re: Is there a limitation on the number of Tasks that can Run in Parellel ?
    ... Allan Mitchell MCSE,MCDBA, www.SQLDTS.com - The site for all your DTS needs. ... >> Before the sending the mail yesterday, I did increase the number of Tasks executed in Parallel to 20 in the DTS Package>> Properties window. ... >> Step Error Source: Microsoft Data Transformation Services Package Step Error Description:SubStep ... Step Error code: 80040428 Step Error Help>> File:sqldts80.hlp Step Error Help Context ID:1100>> Step Error Source: Microsoft Data Transformation Services Package Step Error Description:SubStep>> 'DTSStep_DTSDataPumpTask_10' failed with the following error: OleDBProperty 'General Timeout' already exists in the collection. ...
    (microsoft.public.sqlserver.dts)
  • RE: DTS Hanged When Scheduled
    ... Please feel free to respond to the newsgroups if you need any ... Microsoft Online Support ... | Subject: RE: DTS Hanged When Scheduled ... this behavior occurs because the package is using ...
    (microsoft.public.sqlserver.dts)
  • Re: Import and Schedule DTS on MSDE
    ... The dtsrun utility executes a package created using Data Transformation Services. ... Displays the command prompt options. ... Displays the encrypted command used to execute the DTS package without executing it. ...
    (microsoft.public.sqlserver.tools)