It works if u add group by clause. thanks this what i am looking for.

Thanks

emamuthu

There r couple of ways u can get the owner of Dtspackage

Using selet statment in MSBD database

select * from sysdtspackages where name ='NFDW_LOAD_46_ETRAK_VER_101'

go

Using sys stored procedure

msdb.dbo.sp_get_dtspackage

@name=...

I very sorry for making mistake in passing a parameter

msdb..sp_reassign_dtspackageowner

@name = 'Package Name',

@id = 'FF18ACDD-3FBF-48FF-8E1D-0CE4038D5EE4',

@newloginname = 'sa'

master.dbo.xp_cmdshell 'DTSRun /Sservername

/Npackagename /Uusername /Ppassword'

msdb.dbo.sp_reassign_dtspackageowner name, oldid,newid

This has 3 parameter.

1. name = Name of the package

2. oldid= old user name

(eg) princeton\d34ljls

3. newname=new username

(eg) princeton\df2d3r43