create procedure sys.sp_MSrepl_validate_dts_package (
    @name sysname
     ) AS

    SET NOCOUNT ON

    /*
    ** Declarations.
    */
    if not exists (select * from msdb.dbo.sysdtspackages where
        name = @name)
    begin
        raiserror(21171,
            16, -1, @name, @@servername )
        return 1
    end
    return 0