There are too many assumptions made by the author.  The link provided in the answer references auditing via SQL Profiler.  Did the author mean enabling the auditing feature of SQL...

Mark,

Look into the DTSStepExecStat_Completed or DTSStepExecStat_Waiting constants.  I believe you can set the status of any step in a package via an ActiveXScript task.

I've done something similar but I don't remember...

I have researched the DTSPackageLog in greater detail.  I found a statement that says the package log object is only available in transformations.  Is this true?  I'd like to use...

I'm curious as to why 64KB is the default?  It makes sense in that SQL Server writes to disk in 64K extents.  Is the default set to 64KB for performance...

Just to nit-pick, the question was

Which of the following queries will allow you to check if you have already created a temporary table called #mytable

This means the solution of...

I was not aware of the DTSPackageLog methods.  I think they will solve my problem nicely.

Thanks.

P.S. - I like your graphic with the guy bangin' his head on his desk. ...

I don't want to enable package logging because I'm already maintaining an execution log that gives me much more information then package logging.  Additionally, If I get an error from...

We are evaluating several products for auditing with the goal of tracking object and data changes.  Entegra is one of the products.  "SQL Power Tools" and "SQL Guard" are others.

I'm...

This answers are ambiguous.  The answer is stated to be that one is order by an alias and the other is order by the column name.  Granted, this is true,...