If you turn on logging in the package, it will log each step and tell you which one failed.  In the event of a timeout, you'll see which step was...

Right-click on Database since you're creating the database with the restore.  Select Restore from device and click on the 'Select Devices...' button.  Then you can add you backup files to...

The main reason I use the DROP and CREATE method is so the destination tables can be truncated, which is faster than deleting.  Because my DTS package frequently import large...

I do what Scorpian does.  I use this script to create the drop and add statements for the FK constraints:

/* Generates script to drop foreign key constraints.  If you plan...

The short answer is you can't deny access to Master and Tempdb to a login.  Both databases have the Guest user and Public role, neither of which can be removed. ...

Please post your query.

Greg

I don't have a step-by-step guide, but I suggest http://www.sqldts.com/ and the book "Professional SQL Server 2000 DTS" by WROX as excellent reference material. 

This sounds like a pretty basic...

Jeffrey,

I'm not sure I understand when you say it's difficult to revert to a previous version.  If you save packages to SQL Server, a new version is created each time...

Like a lot of people, my first impulse is to say that I'd like to pursue one of my hobbies as a profession: building and repairing bicycles or cooking. 

After...

Here's a script that will produce statements to drop all the constraints in a database.

select 'ALTER TABLE ' + cast(table_name as char(40)) + 'DROP CONSTRAINT '

       + cast(constraint_name...

Try assigning the results of the @@ERROR query to a global variable that the 'on failure' step can read to get the value.

Greg

Try searching this site for threads regarding this.  I just searched for 'define columns' and found a lot of discussions about this problem.  Perhaps one of them will give you...

1. Open Package Properties in Designer

2. On the Advanced tab, check 'Use transactions' and 'Commit on successful

    package completion'

3. Right-click on each each Data Transformation task and select 'Workflow

    Properties'

4....

Steve,

Are you running Service Pack 3?  This sounds like a bug that was fixed in SP4.

http://support.microsoft.com/kb/814113/en-us

Greg

"Professional SQL Server 2000 DTS" by Brian Knight, Mark Chaffin, Todd Robinson is a great book.  It's full of good examples and clear explanations.  Perhaps it's the Wrox book you've...