You really will get more help if you post the requested information. There are a lot of people on these forums who can and will help, but...

The owner is whomever last saved the package, so the only way I know to change the owner is to have the potential new owner open the package in BIDS...

It looks like DTS was unable to convert the data in the column ret_date to a SQL Server datetime data type. You could try using a query in the...

You have a database backup? Whether it's from a named instance doesn't matter. In instance 2, use

RESTORE DATABASE mydatabase

FROM DISK = 'filepath'

WITH RECOVERY

You'd use variations of this depending...

Okay, here's how I'd do it, briefly:

Job step 1: T-SQL step

if (select day(getdate())) = 1

...

When using EXECUTE AS to impersonate a user, the scope of impersonation is restricted to the current database. You can't use it to access objects in another database unless...

No problem. Are you working in SQL 2005 Management Studio or in SQL 2000 Enterprise Manager and do you know how to create a scheduled job?

I would do the date check in a job step and jump to the appropriate jobe step to execute one of the packages.

Example:

Job step 1: if date is first of...

Your package is no longer a legacy DTS package, but an SSIS package. You must use BIDS to make changes to SSIS packages as the designer is not part...

In Management Studio, right-click on the table, select "Modify", and insert the column. In T-SQL, you'll have to recreate the table and reload the data because ALTER TABLE ADD...

It's not as simple in SQL 2000. You have to grant EXECUTE permission on sp_help_job and sp_get_composite_job_info in msdb.

Did you have some sort of auditing or a profiler trace running at the time the objects were dropped? If not, you probably can't find who dropped them.

If all access is via stored procedures, remove the users from the db_owner role and grant them EXECUTE permission to the dbo owned stored procedures that are used to select...

If the Master database of the original instance is accessible, you can use the method described in http://support.microsoft.com/kb/246133/en-us. If it's not, I think you're out of luck. That's...

There's a script in the script section that purports to compare two databases: http://www.sqlservercentral.com/scripts/Administration/62276/, but there are lots of affordable tools from RedGate, ApexSQL, etc. that make comparison easy.