November 1, 2011 at 4:45 pm
I Get Error Making Copy of SSIS Package, Rename it, add it to the Project when I run it.
I get the error that it can't find the existing Package Name.
I thought that I did this before.
What do I need to change so that I can work from a variation of the existing Package?
Any help would be greatly appreciated.
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/
November 2, 2011 at 1:40 am
Open the .dtproj project file (it's just xml) and check what packages it is trying to open.
If you rename the package, you always get a message that asks you if you want to change the object name as well. Always answer Yes.
Furthermore, also change the GUID of the package when you copy it. You can do this by clicking on the control flow, hit F4, and look for the ID property. By clicking on that property, you can generate a new ID.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply