An alternative to the Data Driven Query task is to copy the external data to temporary staging tables then use TSQL in Execute SQL tasks to find the new and...

I'm not sure I understand your question, but if you want to copy tables schema and data from one database to another database, you can use DTS.

Greg

According to MS, both the 'production' server and the 'standby' server have to be licensed identically if Enterprise Edition log shipping is used.

To get around that, you could roll your...

You can buy a product to read and "beautify" the log info.  Some are Lumigent Log Explorer, LockwoodTech Log Navigator, Coherent Software Log PI.

You can use the undocumented DBCC LOG.

Syntax:

DBCC...

Which server are you trying to schedule the package on?  Source or destination?

Greg

Look at "Date Time String Transformation" in Books On Line.  You'll need to edit the transformation for that field and make the source and destination date format yyyy-MM-dd hh:mm:ss.ffff.

Greg

Also, how about details of the errors you've received when using DTS & TSQL.

Greg

I could be a permissions problem since a scheduled job runs under the SQL Server Agent login rather than your login.

Enable Package logging in the package properties to get more...

I might as well throw in my 2 cents.  I've always equated Oracle & Sql Server this way: 

Oracle                   SQL Server

This exact problem was addressed in another forum last week.  See this Knowledgebase article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q301292

Greg

Turning on package logging will record the record count for each task in a log file that you specify. 

-Open the package in DTS Designer

-Click on package properties

-Click on the...

You don't say what DBCC checks you're doing but try this in your maintenance plan (example uses CHECKDB):

SET QUOTED_IDENTIFIER ON

DBCC CHECKDB(mydb)

Consider using DTS for this.  Replication and log shipping may be a bit complex for what you want to do.  You could create a DTS package and schedule it for...

To clarify, Johnny, active/passive refers to server clustering.  I assume you're not using that since you said you would restore a backup of your production server to your backup server.

Greg

The licensing of the backup server has to be identical to the licensing of the production server because, if you failover, it will be doing the same processing as the...