Andy,

Asumption is the mother of all f**k-ups. I'd test it if I were you!

xp_sendmail is used to send emails. I have never used it though so don't know much about...

I agree that not many people have looked at the product however I expect a great many of those have access to it without knowing it (i.e. through MSDN).

Perhaps MSFT...

You need to test for failure in the called proc and pass a value out to the calling code indicating success or failure. Use a similar approach to what I...

Paul,

Check out this link: http://sqljunkies.com/WebLog/donald%20farmer/archive/2005/02/20/7989.aspx for information on DTS2000 -v- SSIS.

SSIS blows DTS out of the water it seems.

Phill,

Project REAL has provided some real-world experience of migrating from DTS to SSIS. The message seems to be that there is no clear upgrade path, you may have to re-engineer...

I would use GOTO. Like this:

BEGIN Tran

 

stmt1

IF @@ERROR <> 0 GOTO OnError

stmt1

IF @@ERROR <> 0 GOTO OnError

stmt2

IF @@ERROR <> 0 GOTO OnError

 

Nigel,

I've worked at places where this is a policy, not just a cost cutting measure

Seriously though, where this does happen seems, in my...

Michael,

The third CTP (Community Technical Preview) was released at the start of this month. CTPs are interim builds and are not as rigorously tested as beta releases. This particular CTP is...

Andrew,

You can access the DTS object model through VB or VBScript and loop over the connections collection to get the properties that you are interested in.

In BOL look for "DTS...

Mike,

There is no way that the package can know where it has been executed from (which is what you are asking). However you can TELL it where it is being...

Er...probably. Don't take my word for it though.

Point taken about checking for 1 instead of 0 however that would mean changing the behaviour in a system that currently contains over 1000 SPs. So I might leave that...

Ron,

I already use the condition @vReturnStatus <> 0 so the extra check for IS NULL isn't necassary.

proc_parent still wasn't going into my error handling block though. This was because @vReturnStatus...

I imagine that'll be nothing compared to the number of .Net developers that think they can simply bypass a database schema by simply sticking everything in single field of type...

Excited about TRY...CATCH I imagine? We've just been saying here that we need that.