July 17, 2014 at 12:21 pm
Hi,
I have several SSIS packages that were developed in SQL 2005/2008 and upgraded to SQL 2012. These packages are run from SQL Agent jobs. On our old SQL 2008 server, a failed package would display a verbose error message about the failure. On SQL 2012 all I see is "The package execution failed. The step failed."
The logging in the SSIS package appears to be the same in the 2008 version and the upgraded 2012 version.
The old SQL 2008 server was not using SQL Agent property "Include execution trace messages", and the new SQL 2012 server also does not have this option turned on.
The SQL Agent jobs are exactly the same. No extra logging is enabled on the jobs on our old 2008 server.
What do I need to do to get verbose error messages in SQL Agent 2012 for SSIS packages?
July 19, 2014 at 1:14 pm
The error message would not be displayed in the job history in SQL Server 2012 if you are executing a package in the job.
To see the verbose message, go to Integration Services Catalog --> Your Project --> Right click and select Reports --> Standard Reports --> All Executions.
You can click on "All Messages" of a specific execution to see the errors.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply