I created a new SSIS solution, right-clicked the default name "Package.dtsx" (under SSIS Packages), then renamed it. A dialog appears asking "Do you want to rename the package object as well"?
What are they referring to and what are the consequences of doing/not doing so?
Barkingdog
In Visual Studio you rename a file - the *.dtsx file. However, the SSIS package is an object in the file. So if you don't rename the object you could have a package file called MySuperPackage.dtsx containing a package object called MyOldPackage. Try saying no to the dialog once and check the name property of the package in the properties window - select the package by clicking in the background of the object expolorer.
Analysis Services has the same issue with cubes and other objects. The objects are defined in XML and have a name property - which can be different from the filename of the xml.
For this reason, when renaming packages, you should use the designer - do not just rename them in the file system.
Donald
No comments:
Post a Comment