Noticed tlog failed according to application logs error message package failed , I checked systems logs,job history but nowhere the reason is mentioned.
Where I could see the reason of package failed?thank you.
asked Jul 07, 2011 at 03:27 AM in Default
TLOG failed? You mean the transaction log for you database failed or that a transaction log backup failed? Is this a SQL job executing an SSIS package?
answered Jul 07, 2011 at 08:17 AM
You shoudl enable logging in your package in order to view the error message in sysssislog TABLE.
Please read this [link] for a understanding of logging in ssis: http://msdn.microsoft.com/en-us/library/ms167456.aspx
answered Jul 07, 2011 at 11:51 PM