There's no system table or view that stores that information.  I think the best you can do is to save your DTS packages as files and search them.  I have...

Check the syntax of REPLACE.  The second argument should be the string you want to replace. 

From BOL:

REPLACE

Replaces all occurrences of the second given string expression in the first string...

Though I don't share your opinion of Enterprise Manager, I can recommend DBArtisan from Embarcadero. 

Greg

Is your Copy SQL Server Objects task dropping and recreating the destination tables or deleting data in the destination tables and then copying data?  If so, it would be faster...

Have a look at the dtsrunui utility.  It can generate a dtsrun command that can be put in a job step of a scheduled SQL Agent job.  For an example,...

Alpesh,

Try adding the users to TargetServerRole in MSDB.  You may have to give TargetServerRole permission to execute sp_help_job, sp_help_jobstep, sp_help_jobschedule, and sp_help_jobhistory.

Greg

Kevin,

Does the package step generate an error when executed?  I've never tried using temporary stored procedures in a DTS task, but maybe it's saying it can't find the temp stored...

You're going to have to do a little more digging.  Enable package logging by opening the package in DTS Designer, click file, properties, Logging tab, check "log package execution to...

You can also try MS Technet forums.  You need a Passport login to participate, though not for just browsing.

http://www.microsoft.com/technet/community/newsgroups/serveros/win2003.mspx

Greg

Stephen,

What do you see if you run

RESTORE LABELONLY

FROM DISK = 'C:\Inetpub\wwwroot\EHCI\ehcibackup.bak'

Greg

"Disabled" is supposed to mean that a licensing type wasn't chosen during installation, but SQL 2000 had a bug that was fixed in sp2.  And I don't think 'select SERVERPROPERTY'...

A log backup captures all transactions, including incomplete ones, in the tlog.  When a log backup is restored, SQL Server rolls back all transactions that were incomplete at the time...

Wishful thinking.  This is called "multiplexing" and Microsoft isn't giving anyone a break for using it.  From http://www.microsoft.com/sql/howtobuy/multiplexing.mspx , "Use of such multiplexing or pooling hardware and/or software does not...

You might get more responses if you post this in the Replication forum rather than DTS.  Also, put your error message in the body of your post because it doesn't...

An alternative to individual grant statements for SELECT, INSERT, UPDATE, DELETE is to make the database user a member of the fixed database roles, db_datareader and db_datawriter.  That is, if...