I created a sql task where I am simply truncating a table. The FailPackageOnFailure is set to True.

On purpose I have given the sql an invalid table name. ...

Did you find a solution? I have the same problem.

Tha thank you. I'll try this.

I found my problem. The way our DBA gave me access to the database where I'm logging eveyrthing, caused my package to create the table setting the owner to...

OLEDB

I will try deleting it and redoing it. I followed instructions from a book I bought SQL Server 2005 Integration Services (Step by Step). It seem to...

Thank you for responding. Yes, I have turned on logging options at the package level and then defaulted each task to have the same logging options as the package....

I'm trying to implement SQL Server logging for the first time. My table sysdtslog90 was created but nothing is written to it. I have not deployed the package...

Thank you so much. This was my original inclination. However, if I would need to have a job re-run (for specific dates), I wanted to be able to...