Hi,
I built a small application that helps me create new packages by loading a template and modifying some parameters, and eventually save the updated package to a user defined location. This application uses the SSIS programming API.
I know all the packages created this way from the same template will have the same package ID. Is there a way to regenerate the package ID programmatically I don't want to use dtutil.exe, but rather a nice package level method in the API.
Is there such
Thanks.
Regenerating Package ID programmatically
Mithun.Pentuker
A simple and nice API method indeed...
That did it, thanks :-)
theczar
Package.RegenerateID()
http://msdn2.microsoft.com/library/microsoft.sqlserver.dts.runtime.package.regenerateid.aspx
esgibson
How would one go about adding this as a script object in my template
I am thinking of adding to my template a script object named something like "Run me once to reset ID when using this template - then delete". Not being a object orientated script pro, I've been strugling when trying access this method on the current package.
Otherwise I'll just have to add a note to the template saying "Remember to reset the packageID"
Thanks!
Karel Kruizenruiker
I don't know of a method in the API - if it there isn't one - there should be.
Are you aware of that you can do this from within BIDS in the property grid I guess this won't be what you want either tho.
-Jamie