January 2015 Entries

SSIS 2012: My Deployment fails with the message "query the operation_messages view"
The full error message reads as "Failed to deploy project. For more information, query the operation_messages view for the operation identifier '39212'. (Microsoft SQL Server, Error: 27203)

In a nutshell, the most common reason for this is the latency between SQL Server logging the deployment operation within the SSIS catalog database and the stored procs that actually commit the deployment.

Try the deployment again.

Posted On Friday, January 23, 2015 5:49 PM | Comments (0)