DTS packages may fail if you run multiple DTS packages that contain Analysis Services Processing tasks at the same time (870620)

SYMPTOMS

In Microsoft SQL Server 2000, you receive one of the following error messages:

Error message 1

Error = -2146828197 (800A005B) Error string: Object variable or With block variable not set Error source: DSO

Error message 2

Error = -2147417848 (80010108) Error string: Object Invoked has disconnected from its clients. (DSO (80004005): Method '~' of object '~' failed) Error source: Microsoft Data Transformation Services (DTS) Package

WORKAROUND

To work around this problem, use one of the following methods:

Method 1

Run each DTS package serially. To do this, you can either create a workflow dependency between the tasks in a DTS package or you can schedule the DTS package to run as a dependent step in a SQL Server Agent job.

Method 2

Use the Analysis Services Parallel Processing utility to process the Analysis Services objects. This utility manages and controls the processing of Analysis Services cubes and partitions. The Analysis Services Parallel Processing utility is a sample Decision Support Objects (DSO) program. You can use the Analysis Services Parallel Processing utility to process Analysis Services objects at the same time. The Analysis Services Parallel Processing utility does this by implementing code to exclusively access the Analysis Services objects. You can run the Analysis Services Parallel utility program at a command prompt or from an operating system command step in a SQL Server Agent job. To download the Analysis Services Parallel Processing utility, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyId=A2EEF773-6DF7-4688-8211-E02CF13CBDB4&displaylang=en

Method 3

Create a custom Decision Support Objects (DSO) program to process the Analysis Services objects. The Analysis Services Parallel Processing utility contains Microsoft Visual Basic source code. You can create a custom program that is based on the source code in the ProcessPartion.exe program. The ProcessPartion.exe program does the actual processing of the cube or the partition. For more information about the Analysis Services Parallel Processing utility, see the Readme.doc file in the installation folder.

Note You must have Microsoft Visual Studio 6.0 to compile the source code.