CODEWITHSUNDEEP
sql-servervisual-studio-2010visual-studiossis
Bartek Boro
Bartek Boro

Reputation: 165

Executing SSIS package crashes Visual Studio

I run into a problem, when I try to execute a SSIS package from Visual Studio either by "Execute package" from solution explorer, or "Execute task" from designer itself, there is an error that states "visual studio encountered a problem and needs to close" and it restarts. After restart I've noticed that input files for package are inaccessible because two tasks "SSIS debug host" and "SSIS debug host 32bit" are still running.

Funny part is, that in one try out of let say ten, everything goes ok...

In Event viewer I've found two events that link to this problem: http://codeviewer.org/view/code:3ac1

My specification: -VS2010 Ultimate with SP1 -SQL 2012 Developer with SP1 -Win8.1

I've tried to reinstall VS and repair installation of SQL and it didn't worked.

Any thoughts what to check?

Upvotes: 5

Views: 6197

Answers (1)

Bartek Boro
Bartek Boro

Reputation: 165

So here is what happened to work for me in my situation: I had to create a separate solution file, that consist only SSIS projects and Datacube projects, then was able to execute packages within Visual Studio without random crashes.

Upvotes: 2

Related Questions