question

pits avatar image
pits asked

package failed

Hello Experts, 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.
errormessage
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
SirSQL avatar image
SirSQL answered
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?
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

aRookieBIdev avatar image
aRookieBIdev answered
You shoudl enable logging in your package in order to view the error message in sysssislog TABLE. Please read this [link][1] for a understanding of logging in ssis [1]: http://msdn.microsoft.com/en-us/library/ms167456.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.