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
Hi Rupesh, See if this link can help you http://technet.microsoft.com/en-us/library/ms167456.aspx and http://blogs.conchango.com/jamietho...get_3A00_-Dynamically-set-a-logfile-name.aspx Regards