SQL Server Integration Services throws "Error Starting Debugging" - Failed to start project

Question

Several of my colleagues and I are experiencing a problem: we are trying to use the Visual Studio Business Intelligence Designer (BIDS) to create and debug SQL Server Integration Services packages. In nearly all cases, we encounter the error below.

We all have SQL Server 2008R2 Management Studio installed, which includes the Visual Studio 2008 BIDS IDE. We all have Visual Studio 2010 installed as our primary development IDE / environment, and connect to a Team Foundation Server source control.

We do not have a source control plugin selected for the BIDS IDE.

We are all running Windows 7 with all the latest service packs and patches (as far as we know- these are customer-managed machines and the patch management details are opaque to us).

The one thing that is different - maybe - between the one system where the SSIS debugger DOES work and the several where it DOESN'T work is that- MAYBE- the operable system has not been used to edit SQL Server Reporting Service RDL files, where the rest have been.

In the Project Properties dialog, under the Debugging options: We have tried setting the "runInOptimizedMode" option to False - no joy. We have tried setting the "Run64BitRuntime" option to False- no joy. We have tried setting the "InteractiveMode" option to "False" - no joy.

Here is the error text as reported by the BIDS interface.

Thanks for any insights you have!

---

TITLE: Microsoft Visual Studio

Failed to start project

---

ADDITIONAL INFORMATION:

Error starting debugging. (Microsoft.DataTransformationServices.VsIntegration)

---

Unable to start program 'C:\Users\\Documents\Visual Studio 2008\projects\DebugTest\DebugTest\Package.dtsx'.

Operation not supported. Unknown error: 0x80040038. (Microsoft Visual Studio Debugger)

---

BUTTONS:

OK

Answer 1

Run Visual Studio as Administrator that works for me