I have a DTS package I am trying to build that contains 2 tasks and a
workflow. The first task is a Dynamic Properties Task that takes the values
of global variables and places them in the properties of the custom task.
The workflow simply runs the custom task if the Dynamic Properties Task
succedes. The problem that I have is that when I run the package via
DTSRUN, I get the following output:

DTSRUN /Spsc1204 /NSubmitCPRRequest /E /ADBName:8=NITSSDEV
/ADBServerName:8=psc1204 /APPDID:8="N01-05532"

DTSRun: Loading...
DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSDynamicPropertiesTask_1
DTSRun OnError: DTSStep_DTSDynamicPropertiesTask_1, Error = -2147221499
(80040005)
Error string: Code execution exception: EXCEPTION_ACCESS_VIOLATION
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100

Error Detail Records:

Error: -2147221499 (80040005); Provider Error: 0 (0)
Error string: Code execution exception: EXCEPTION_ACCESS_VIOLATION
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp
Help context: 1100

DTSRun OnFinish: DTSStep_DTSDynamicPropertiesTask_1
DTSRun: Package execution complete.



The custom package is a DLL I have created in VB6. I am running SQL Server
2000 SP2.

Does anyone have any suggestions as to how to fix this?

TIA
Ron Lounsbury

This URL points to about 24 threads in Google that involve DTS and this
error message on SQL Server 2000 SP3. Maybe you can regurgitate some help
from there?
http://tinyurl.com/nuhq




"Ron Lounsbury" <rlounsbury AT Progeny DOT net> wrote

Aaron
Thanks for the reply. It turned out that I needed the "Execute on main
package thread" checkbox checked on BOTH tasks, not just on the custom task.
That seems to have taken care of it.

Ron Lounsbury


"Aaron Bertrand - MVP" <aaron (AT) TRASHaspfaq (DOT) com> wrote