posted 11/12/2010 by timmurphy - Views: [1810]
Answering this question the wrong way can have at least one undesirable effect on your package that I know about.I was following someone else’s work and adding logging to a package and was using a system variable to append the package name to a file name with a timestamp. Easy enough, right? (Check out http://bidn.com/blogs/timmurphy/ssas/1246/append-timestamp-to-log-file-name). The first problem was following after someone that didn't use best practices, but that's another story. It seems that the original person had renamed the package and had said "No" to renaming the package object as well. The system variable in my expression uses the package object name, so you can imagine how confused I was when I looked at the Log Files and saw a different spelling than the package name. If only I had thought of this sooner it would have saved some time trying to figure out why the log file wasn't where it was supposed to be. Anyway, I always say "Yes" to renaming package object as well, mainly because it is the default answer, but now we know another reason to do so. If you know a good reason to say "No" to the above, please post a comment.
Answering this question the wrong way can have at least one undesirable effect on your package that I know about.
I was following someone else’s work and adding logging to a package and was using a system variable to append the package name to a file name with a timestamp. Easy enough, right? (Check out http://bidn.com/blogs/timmurphy/ssas/1246/append-timestamp-to-log-file-name).
The first problem was following after someone that didn't use best practices, but that's another story. It seems that the original person had renamed the package and had said "No" to renaming the package object as well. The system variable in my expression uses the package object name, so you can imagine how confused I was when I looked at the Log Files and saw a different spelling than the package name. If only I had thought of this sooner it would have saved some time trying to figure out why the log file wasn't where it was supposed to be.
Anyway, I always say "Yes" to renaming package object as well, mainly because it is the default answer, but now we know another reason to do so. If you know a good reason to say "No" to the above, please post a comment.
I too have always chosen yes. This is an interesting post, thanks for showing me another good reason to answer yes to this dialog.