I'm encountering a problem with SSIS which i've not ever experienced before. I'll create a solution, work on the .dtsx file, save it, run it, etc and everything is fine. Then suddenly at some point i'll make a change - add a new data flow, for example - and then when I go to save the package i'll get a window which says I do not have permission to access the file. Trying to create another solution and attaching the package .dtsx file doesn't work, either, as I get the same permissions issue. Checking the permissions on both the file and the folder, I see that I have full control of both. Last week when I encountered this issue I simply restarted the machine and everything was fine. Today, however, after the restart the package .dtsx file is completely GONE from my hard drive.
What the hell could be causing this issue? I've used SSIS for years now and have never ever experienced this before.
How do I get my package file back, and how the hell do I prevent this from happening in the future?
I'm using SSIS 2008 and saving my solution files to the default Projects folder (C:\Users\MyAccount\Documents\Visual Studio 2008\Projects)
Ugh....the joys of SSIS.