SQLSecurity.com has a security checklist that lists extended stored procedures that should be restricted to sysadmins.  Have a look:

http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=24

Greg

Local packages are stored in SQL Server, not on a client PC.  Does the ActiveX task use a file whose file path is designated with a mapped drive rather than a UNC...

Use the sp_reassign_dtspackageowner stored procedure in msdb to change ownership to his new login.

Greg

1.You could use a Transform Data task with  lookup  instead of the Bulk Insert task.

2. You could Bulk Insert into a work table then use an SQL task to join it...

You can use DTS to either transfer data to an existing table or create an identical table then transfer data.  It's your choice.

If you want to transfer table schema and...

Jaishree,

If you have SQL Server 6.0, you'll have to upgrade to either v6.5 or v7.0 before upgrading to 2000.

See this MS TechNet white paper on upgrading -

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/sqlugrd.mspx#XSLTsection125121120120

Greg

I don't know if this is more elegant but it's quicker than double-clicking on each transformation task and going to the options tab.

Start Disconnected Edit in DTS designer, expand Tasks,...

Hector,

Create a job and just make a job step for each database backup.  Each step will contain a BACKUP DATABASE statement, the syntax of which is available in Books Online.

Greg

Do you have a backup that you can restore?

I see what you're getting at, now.  Consider this: The plan in the article specifies copying the log backup file to the standby server and restoring it immediately after the...

The only way I know to restore all the backup sets without interruption is to do it in Enterprise Manager.  All backup sets are listed and you can check all...

If your packages were saved to SQL Server and if you have a backup of the MSDB database, you can restore the packages by restoring the database. 

Greg

FILE is used to specify which backup set to restore from a backup device that contains multiple backup sets.  For example, if your backup device contains log_bkup1, log_bkup2, log_bkup3, then FILE=1 specifies that log_bkup1...

We don't have stored procedures in the "common object" database.  If an application needs to access the common tables or views, the stored procedure is kept in the application's database...

I agree with Steve.  Save yourself the hassle of managing a bunch of separate backup files and just append all the log backups for a day to the backup device...