embedding a DTS package and logging/error reporting

Hi All,

When the embedded DTS package fails at runtime, and logging has been enabled for the package (and all log events selected for reporting on for the package and the task), the DTS error (i.e. any meaningful errors) are not thrown up to/caught by the SSIS/outer level. All you get is something like:

COMException - error returned from a call to a COM component.

Does anyone have any comments &/or know to get errors thrown from within an embedded DTS package, thrown up to the wrapping SSIS package?

Cheers,

Tamim.

Hi Tamim,

Try configuring your DTS package (using the old SQL 2000 designer) to log to an msdb database (it can be a SQL 2005 msdb). Then you will find the DTS messages logged to the tables eg sysdtspackagelog and sysdtssteplog.

Good luck.

Mike

embedding a DTS package and logging/error reporting

Hi All,

When the embedded DTS package fails at runtime, and logging has been enabled for the package (and all log events selected for reporting on for the package and the task), the DTS error (i.e. any meaningful errors) are not thrown up to/caught by the SSIS/outer level. All you get is something like:

COMException - error returned from a call to a COM component.

Does anyone have any comments &/or know to get errors thrown from within an embedded DTS package, thrown up to the wrapping SSIS package?

Cheers,

Tamim.

Hi Tamim,

Try configuring your DTS package (using the old SQL 2000 designer) to log to an msdb database (it can be a SQL 2005 msdb). Then you will find the DTS messages logged to the tables eg sysdtspackagelog and sysdtssteplog.

Good luck.

Mike

sql

email notifications

All,
When i needed to use email notifications in the past with a sql cluster I had to "forward" events and messages to a non clustered server with a MAPI client installed. This is because outlook 2000 and previous was not cluster aware.
Does anyone know if Outlook 2003 is cluster aware?
Does anyone have a better alternative to using outlook for SQL email notofication? For a cluster?
TIA
Outlook 2003 is not cluster aware.
Try xpsmtp from www.sqldev.net as an alternative.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Detroit" <anonymous@.discussions.microsoft.com> wrote in message
news:74F273D8-E837-4640-B3A1-E11AF06CBE36@.microsoft.com...
> All,
> When i needed to use email notifications in the past with a sql cluster I
had to "forward" events and messages to a non clustered server with a MAPI
client installed. This is because outlook 2000 and previous was not cluster
aware.
> Does anyone know if Outlook 2003 is cluster aware?
> Does anyone have a better alternative to using outlook for SQL email
notofication? For a cluster?
> TIA
|||Detroit,
Blat is a command line E-Mail program that is relatively easy to use. You should be able to create a batch process to accomplish this.
Bob G.