August 18, 2009 at 9:17 am
I am trying to be able to uniquely identify a package being stored in the MSDB. I thought the [id] column in the sysdtspackages90 table would do it, but I have several packages that share the same [id]. I also tried the verid column, but that changes every time you update the package....so that wouldn't really help.
Does anyone have any ideas?
Thanks!
Michael
August 18, 2009 at 1:14 pm
Execute sp_help sysdtspackages90
Shows us that the primary key has been defined on the following columns: folderid, name
That should uniquely identify the row - which should also uniquely identify the package.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 19, 2009 at 5:22 am
Michael Esposito (8/18/2009)
I am trying to be able to uniquely identify a package being stored in the MSDB. I thought the [id] column in the sysdtspackages90 table would do it, but I have several packages that share the same [id]. I also tried the verid column, but that changes every time you update the package....so that wouldn't really help.Does anyone have any ideas?
Thanks!
Michael
Michael,
The ID is generated when you open a new package. So if I create package 1 it will have a unique ID. Now should I ever copy that package or use it as a template it will have the same ID.
ID and name should do the trick. Good practice would be locate those packages with duplicate IDs open them and on the package poroperties click ID and take the option generate ID.
Ells.
😎
August 19, 2009 at 10:29 am
If you copy a package it will have the same ID (guid) as the original.
After a package is copied, you should open the copied package and generate a new guid by selecting from the package ID property dropdown.
August 19, 2009 at 10:30 am
If you copy a package it will have the same ID (guid) as the original.
After a package is copied, you should open the copied package and generate a new guid by selecting
Generate New ID
from the package ID property dropdown.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply