Do we have log file for SSIS package, I have a sql server job in SQL server 2005 which is executing SSIS package.

Now, Job fails sometimes and doesn't give any error. Can I check SSIS log file if there is any ??

Thanks in advance.

Rupesh

I have jobs which run ssis packages.
If there are errors I look at job history.

Hope this helps.

 Thanks

Hi Rupesh,

See if this link can help you http://technet.microsoft.com/en-us/library/ms167456.aspx and http://blogs.conchango.com/jamiethomson/archive/2006/10/05/SSIS-Nugget_3A00_-Dynamically-set-a-logfile-name.aspx

Regards