 | |
DTS Package Order
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DTS Package Order -
04-24-2006
, 10:05 AM
#2
| |||
| |||
|
|
This is driving me crazy. It appears when you try to select the Package Name for a Execute Package Task, the drop down list is populated by sp_enum_dtspackages. The problem is that this sorts by package ID and not by package name. There doesn't seem to be a way to modify sp_enum_dtspackages since it is a system stored procedure. Is there anyway to get the list to sort by name? |
#3
| |||
| |||
|
|
How about just query sysdtspackages and order by name yourself? -- Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com "Treyco" <Treyco (AT) discussions (DOT) microsoft.com> wrote in message news:1DC8B9E6-3F73-4280-B26C-01627CB4C2B1 (AT) microsoft (DOT) com... This is driving me crazy. It appears when you try to select the Package Name for a Execute Package Task, the drop down list is populated by sp_enum_dtspackages. The problem is that this sorts by package ID and not by package name. There doesn't seem to be a way to modify sp_enum_dtspackages since it is a system stored procedure. Is there anyway to get the list to sort by name? |
#4
| |||
| |||
|
|
I can get a name ordered list. What I can't figure out how to do is get the drop down in the GUI to use a name ordered list. Trey "Allan Mitchell" wrote: How about just query sysdtspackages and order by name yourself? -- Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com "Treyco" <Treyco (AT) discussions (DOT) microsoft.com> wrote in message news:1DC8B9E6-3F73-4280-B26C-01627CB4C2B1 (AT) microsoft (DOT) com... This is driving me crazy. It appears when you try to select the Package Name for a Execute Package Task, the drop down list is populated by sp_enum_dtspackages. The problem is that this sorts by package ID and not by package name. There doesn't seem to be a way to modify sp_enum_dtspackages since it is a system stored procedure. Is there anyway to get the list to sort by name? |
#5
| |||
| |||
|
|
Ok So I have just reread the original post and in this case I know of no way to change the behaviour of the Execute Package task to give you the list any other way than executing the proc you mention. -- Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com "Treyco" <Treyco (AT) discussions (DOT) microsoft.com> wrote in message news:A0D98FA7-9103-40B9-9A88-914895EB4FAD (AT) microsoft (DOT) com... I can get a name ordered list. What I can't figure out how to do is get the drop down in the GUI to use a name ordered list. Trey "Allan Mitchell" wrote: How about just query sysdtspackages and order by name yourself? -- Allan Mitchell www.SQLDTS.com www.SQLIS.com www.Konesans.com "Treyco" <Treyco (AT) discussions (DOT) microsoft.com> wrote in message news:1DC8B9E6-3F73-4280-B26C-01627CB4C2B1 (AT) microsoft (DOT) com... This is driving me crazy. It appears when you try to select the Package Name for a Execute Package Task, the drop down list is populated by sp_enum_dtspackages. The problem is that this sorts by package ID and not by package name. There doesn't seem to be a way to modify sp_enum_dtspackages since it is a system stored procedure. Is there anyway to get the list to sort by name? |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.