Regenerating Package Id's

I noticed that when you copy/paste your packages the package ID stays the same as the original. This can be a problem when reading reports and such...

I recently saw a webcast in which there was a brief talk about this problem and the workaround was to regenerate the package ID's, however, no explanation on how to do so.

Does anyone know how to regenerate package id's

thanks in advance,
Jason

Software: SSIS JuneCTP

Answer this question

Regenerating Package Id's

John Samperi
This is all well and good, but what about task IDs in those copied packages See the other thread just started on this problem... Task IDs are read only.

skinnybit

From Article ID : 906564
Last Review : March 11, 2006
Revision : 2.0

Use SQL Server Business Intelligence Development Studio

1.	Open the package in SQL Server Business Intelligence Development Studio.
2.	Click the Control Flow tab.
3.	Click the ID property. In the drop-down list, click <Generate New ID>. A new value appears in the ID property.

My question is: Where is this ID property found after I click on the Control Flow tab

IanO

Michael B. Price
Jason,

This functionality is available via DTUtil using the /IDRegenrate option or by selecting <<Generate New ID>> from the drop down for the package ID property in the designer.

Unfortunately, this is not in the June CTP, but will be in the next CTP.

HTH,
jefri besharati
is in the propeties pane; if it is not visible, just press F4
Regenerating Package Id's

Answer this question