I converted DTS package to SSIS using DTSXchange. It was successfully converted. My SSIS package has a activeX script. Below is sample activex script Function Main() strSuccess = =0 if strSuccess = 1 then Main = DTSTaskExecResult_Success else Main = DTSTaskExecResult_Failure end if End Function If I comment the line Main = DTSTaskExecResult_Failure it runs successfully. I am not sure why this is happening. Thanks for help.