Hello,

I have been a DBA for over 5 years now, mostly on MS SQL Server. This
is a strange problem that I have never run accross before...

It runs fine under execute package, but the job fails. I have looked
for a solution on Google, Microsoft, etc, but none of the questions I
find fit my problem...

I have a complex DTS package that runs as a job. The user who created
and owns the DTS is a Local Admin, and in the System Admin role, the
SQLServerAgent login is a System Admin.

The code that stops and sets the step to inactive is in the workflow
properties and is as follows: (Editted to remove proprietory
information)

'************************************************* *********************
' Visual Basic ActiveX Script
'************************************************* ***********************

Function Main()

if DTSGlobalVariables("VarName").Value = 0 then
main = DTSStepScriptResult_DontExecuteTask
else
Main = DTSStepScriptResult_ExecuteTask
end if
End Function

'************************************************* **

However every time I run this script using a job (OS command using
"DTSRun /SServerName /E /N"DTS Name Here" it says it fails with the
following data in the "Show Step details" window.
---------------------------------------------------------
Executed as user: Comp...\User.... DTSRun: Loading... DTSRun:
Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun
OnFinish: DTSStep_DTSActiveScriptTask_1 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_3 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart:
DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnFinish:
DTSStep_DTSDynamicPropertiesTask_1 DTSRun OnStart:
DTSStep_DTSActiveScriptTask_2 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_2 DTSRun OnStart:
DTSStep_DTSDynamicPropertiesTask_5 DTSRun OnFinish:
DTSStep_DTSDynamicPropertiesTask_5 DTSRun OnStart:
DTSStep_DTSDynamicPropertiesTask_4 DTSRun OnProgress:
DTSStep_DTSDynamicPropertiesTask_4; Step was not run; status was set
to Inactive.; PercentComplete = 0; ProgressCount = 0 DTSRun
OnFinish: DTSStep_DTSDynamicPropertiesTask_4 DTSRun: Package
execution complete. Process Exit Code 8. The step failed.


-----------------------------------------------------------
Anyone have any ideas... I'm stumped because I have other DTS's that
do this same thing based on file sizes or other criteria and they
aren't erroring out.

Thanks in advance
Ryan S.
DBA/Programmer
Microsoft DBA MCP