March 28, 2012 at 7:10 am
I make a copy of a DTS Package and place it into a folder in another solution.
I try to rename and I get an error that it is in use by another process.
I click on designer and I get a message that the document has been renamed, deleted or removed.
What could cause this?
I just copied and renamed another package a few minutes ago.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 28, 2012 at 7:20 am
I deleted all of the dtsx files in the cfolder and copied the file again and I was able to rename it.
:unsure:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 28, 2012 at 6:17 pm
It does seem that BIDS keeps track of its packages and doesn't take too kindly to background operations.
Sometimes it will somehow lose a package that is currently open and ask you to SaveAs when you close the package (and if you don't the package disappears for good).
I've found the most reliable way to move packages arouns is to use the Add Existing Package option when right clicking on the solution/project.
It has been a while since I encountered that particular error though. Does it only give you that error if the package is open at the time?
March 28, 2012 at 11:42 pm
sam.dahl (3/28/2012)
It has been a while since I encountered that particular error though. Does it only give you that error if the package is open at the time?
I get that error from time to time after copy pasting packages (usually in the same solution).
Just close BIDS, re-open and it works. 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply