DTS Constant

#1

Dear all,

Is there any constant which be able to stop the DTS and return OK?

Does anyone knows if such constant is available?

Regards,

#2

Enric,
return
DTSTaskExecResult_Success
from your main, and that will return OK,
Main = DTSTaskExecResult_Failure would be for NOT ok.
Enric wrote:

Quote:

Dear all,

Is there any constant which be able to stop the DTS and return OK?

Does anyone knows if such constant is available?

Regards,

--
Message posted via http://www.sqlmonster.com

#3

thanks a lot,
regards

"etcarine via SQLMonster.com" wrote:

Quote:

Enric,
return
DTSTaskExecResult_Success
from your main, and that will return OK,
Main = DTSTaskExecResult_Failure would be for NOT ok.
Enric wrote:
Dear all,

Is there any constant which be able to stop the DTS and return OK?

Does anyone knows if such constant is available?

Regards,

--
Message posted via http://www.sqlmonster.com

#4

In message <1F03C6F0-3D16-4F0E-BE21-D348FD0F32FD (AT) microsoft (DOT) com>, Enric
<Enric (AT) discussions (DOT) microsoft.com> writes

Quote:

thanks a lot,
regards

"etcarine via SQLMonster.com" wrote:

Enric,
return
DTSTaskExecResult_Success
from your main, and that will return OK,
Main = DTSTaskExecResult_Failure would be for NOT ok.
Enric wrote:
Dear all,

Is there any constant which be able to stop the DTS and return OK?

Does anyone knows if such constant is available?

Regards,

You may also want to look at workflow scripts, These can be used to halt
the flow of a package, and don't raise an error. For example-

How can I check if a file exists?
(http://www.sqldts.com/default.aspx?211)

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS Constant

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS Constant - 07-29-2005 , 06:03 AM

Re: DTS Constant - 07-29-2005 , 10:03 AM

Re: DTS Constant - 08-01-2005 , 07:01 AM

Re: DTS Constant - 08-01-2005 , 02:09 PM