Query to change the owner of the DTS package in sqlserver2000:

 DTS Package owner change:





Parameters descriptive:

Package_name ->specify name of the package.

Package_id ->get the id value from below output for the corresponding packages.

use msdb
select * from sysdtspackages

Moreover we can take idvalue for the latest ‘created date’ column from the above table.


Popular posts from this blog

SSIS2008R2 Error: 0xC0209303 at Package:

SQL2008R2 Error: The remote copy of database "XXXXX" has not been rolled forward to a point in time that is encompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)