May 21, 2013 at 10:15 am
This strange thing is happening: I am creating a new package, always has to happen by starting from an existing one (because they all run in a framework and there are a lot of variables defined). So I import an existing package (from SQL storage on the production server), and when I try to rename it, it says "The process cannot access the file because it is being used by another process". I tried finding the file, anyhow, I finally rebooted. Now it displays that the new dtsx name "already exists in this project", and on subsequent attempts, it went back to "file is being used by another process". I tried closing everything, delete my projects, delete the backup folders in VS2008, reset all settings in VS2008. Finally, I went on a test server, and added the package there to a new project, and when I try to rename it, it does the same!! makes me believe there is something in MSDB on the production server, but I can't find anything (in sysssispackages)... any ideas? thanks!
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply