sysdtspackages

#1

Hoe do I get the latest DTS version ID with an sql statement?

#2

Substitute the DTS id in the following statement with yours:

select versionid from sysdtspackages a
where id = '5312AAE0-49C7-496F-9837-DF1FD2D12E2D'
and createdate = (select max(createdate) from sysdtspackages b where a.id =
b.id)

--
AndyP,
Sr. Database Administrator,
MCDBA 2003

"Fab" wrote:

Quote:

Hoe do I get the latest DTS version ID with an sql statement?

#3

worked Thx!!
"Fab" <zzaro (AT) excite (DOT) com> wrote

Quote:

Hoe do I get the latest DTS version ID with an sql statement?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

sysdtspackages

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

sysdtspackages - 03-20-2006 , 12:40 PM

RE: sysdtspackages - 03-20-2006 , 01:31 PM

Re: sysdtspackages - 03-20-2006 , 01:47 PM