You can't create or restore a database with DTS.  You can only copy objects and data, not the database itself.  You should use SQL Server BACKUP and RESTORE for replacing...

Truncate permission also defaults to the table owner.  If the operator were the owner of the staging tables he or she could truncate them but not others in the database.

Greg

Maybe, if the job step with the RESTORE command is run as dbo.

I haven't done it, but it should be entirely possible providing you have the mysql ODBC driver installed on the SQL Server where you'll execute the DTS package.

Greg

I recommend "Inside SQL Server 2000" by Kalen Delaney, any of Ken Henderson's books, and SQL Server Books Online, which is SQL Server's user manual and is included with SQL...

Walter,

My Oracle skills are a little rusty, but why can't you just create a sequence (Oracle's equivalent of SQL Server identity) for the Oracle table and not bother to generate...

Yvan,

I can recommend Lumigent Log Explorer.  We've used it for the past three years and it's worked well.

Greg

It's possible.  SQL Server Agent must run as a domain account and must have permission to write to the remote location.  When creating the backup device, enter a UNC path...

Be aware that a member of dbcreator server role can restore any database in the instance.  I believe the only way to restrict the RESTORE permission to a particular database...

"Error string:  [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. "

I agree with Luke.  Open the package and check the SQL Server connections.  My guess is you didn't change the...

You can add multiple schedules for a job in Enterprise Manager.  Open the the job properties, click on the Schedules tab, and click on the New Schedule button.  As you...

I don't think it's a bug.  I think the database property ANSI_WARNINGS has been set off for the destination database.  See 'SET ANSI_WARNINGS' in BOL.

Greg

The message means that the table doesn't exist.  Is it owned by someone other than the database owner? 

Greg

Is MSDM_Import an object in your source database?

Greg

You can also use the Import/Export wizard to copy the structure and permissions.  Use the third option, "Copy objects and data between SQL Server databases".  Check the "Create destination objects"...