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?