Solved

Microsoft Visual Studio is busy

Posted on 2011-02-18
5
2,606 Views
Last Modified: 2012-06-22
I've done a lot of surfing on this, I'm at v2008 SR2, all the latest sp's, I cannot figure out what is causing this.

A very simple SSIS dtsx package, just a data flow task, ole db data source, csv flat file output, it reads from a view.  That's it.  I have been beating the heck out of it for a week, generated 100's of files successfully, and now suddenly it won't work.

I go into BIDS, open the package, in the bottom right it says 'Validating packagename', the cursor is an arrow with two ends, i cannot touch anything.  I cannot close BIDS normally, I have to terminate the exe via task manager, then i open it again.  I open the project, immediately get the 'Microsoft Visual Studio is busy, "Microsoft Visual studio is waiting for an internal operation to complete. If you regularly encounter this delay during normal usage, please report this problem to Microsoft."

I even tried creating a new project, new dtsx, it does the same thing.

I MUST get these files completed like yesterday.

Does anybody have any clue on how to get around this?
0
Comment
Question by:dbaSQL
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 38

Expert Comment

by:Jim P.
ID: 34935608
Have you restarted the SQL Services lately? Or the server?

Have you looked at the activity monitor and seen if anything is blocking?

What kind of configuration -- Server, memory, server versions, SQL versions?

0
 
LVL 17

Author Comment

by:dbaSQL
ID: 34935689
Yes, the service has been restarted.  Nothing is blocking anything.

SQL v2008 R2, 24G ram, Windows Srv 2008 R2 Enterprise, 64bit
0
 
LVL 17

Accepted Solution

by:
dbaSQL earned 0 total points
ID: 34940426
I honestly don't know what the problem was, but I created the package on another instance successfully, and it is running.  The package is still unusable on the other instance, VS is busy, and I can't get any further than that.

but, it's running on another instance, so I'll just leave it at that.

thank you for looking this way, jimpen.
0
 
LVL 38

Expert Comment

by:Jim P.
ID: 34943357
I've had it happen to me when I've loaded SQL on a workstation, had large databases to test and the SQL Agent was doing its stuff. I would take a quick look at the disk(s) and the disk channel on that instance.
0
 
LVL 17

Author Closing Comment

by:dbaSQL
ID: 34978094
It's working on another instance, no reason to keep this open.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question