| Bhaskar 2006-04-06, 1:30 pm |
| Hi,
I have created a DTS package to load the data from the one server to
another server. To load this data i have one Flag which is defined in the
desitination server table. If this flag is 1 then i have to load the data,
other wise i have to exit the dts package sucessfully. to do this i have
created the two activex scripts and using this. i am exectuing this from the
job. looks like this is giving the job failed message.
My flow is something like below
IF Script 1 is Success then it will execute the other tasks and load the
data.
IF Script 1 is Failure then it will excute the Script2.
Active script 1:
Function Main()
Dim isLoadBudgetFlag
isloadFlag= DTSGlobalVariables("isloadFlag").Value
IF isloadFlag=1 THEN
Main = DTSTaskExecResult_Su
ccess
ELSE
Main = DTSTaskExecResult_Fa
ilure
END IF
End Function
Active script 2:
Function Main()
'msgbox("Failed Successfully")
Main = DTSTaskExecResult_Su
ccess
End Function
i want to exit successfully..
Thanks in advance
Bhaskar
|