SQL Server Integration Services has encountered a problem

Asked By Hall Allen 80 points N/A Posted on - 09/27/2012

Hi Experts,

SQL Server Integration Services has encountered a problem. It has failed to deploy the project. Look at the screenshot.

It says

Failed to deploy project. For more information, query the operation_messages view for the operation identifier ‘28120’. (Microsoft SQL Server, Error; 27203)”. Please give a remedy of this issue.

Thanks in advance.

• Status: Open
• Question Views: 2999
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Nicke Baker 0 points N/A #192958

SQL Server Integration Services has encountered a problem

Hello Hall,

To resolve that issue, you will need to just keep trying to deploy the project repeatedly. This is not a sure solution but there is a 50/50 percent chance that it will work without throwing the issue above.

Just use the brute force repeated deployment of the new SSIS Project Deployment Model to resolve the issue.

Regards,

Nicke

About Nicke Baker

Questions
0

Answers
671

Best Answers
100

• Vote Up 0 Vote Down

• Posted on - 09/27/2012
• Question Category: MS SQL Server