Okay, I'll give that one, Jack. My answer was probably a bit broad considering the little information the OP gave us.

Hundreds of log backups for a single full backup? Maybe you should consider scheduling some differential backups between the fulls. That can drastically cut down on the number...

You...

If you used DTSBackup2000, you saved them as DTS packages in the SQL 2005 instance. You can see them in SSMS Object Explorer by expanding Management, Legacy, Data Transformation...

Yes.

db_datawriter. You'll probably want to add the user to db_datareader also so he can select data.

See this thread for links: http://www.sqlservercentral.com/Forums/Topic711917-145-1.aspx

The first and last LSNs of a backup set are stored in backupset table in msdb, so you probably don't need to track them yourself.

While it's possible to restore to...

Sounds like what you need is an SSIS package with a Data Flow Task that transfers data from the d1 database to the d2 database. In that case, you...

Please explain what you want to "backup". Since you want to use SSIS, I assume you want to copy data from one database to another.

Glad you figured it out.

Maybe all the DTS runtime components aren't present. See if this article helps: http://support.microsoft.com/kb/919131.

Have you considered using DTS? You can map columns in the source tables to columns in the destination tables regardless of the column names and you can do some...

The encrypted command needs to be changed because the package is in a new instance. See my reply to your post in the SQL Agent forum (http://www.sqlservercentral.com/Forums/Topic708454-110-1.aspx#bm709515) to see...

Kent Zhou (5/1/2009)

---

Great! Thank you very much.

With your first suggestion:

In SQL 2005 and 2008 Management Studio, you have to create the jobs in SQL Server Agent and add the DTSRUN...