Hi everyone.

I have a question that maybe some of you may be able to shed some light
on. My set up involves three SQL Server Databases. First one, used by
the application. Second, copy of first via log shipping. Third,
contains data aggregation from the Second. Now, my issue is that I
have a DTS packagage that (COPY SQL SERVER OBJECTS) that copys select
tables from the second DB, into the third. The issue lies when the DTS
package executes, everyonce in a while it errors out. I'm assuming
it's an error due to the log shipping restore on the second database.
Are there any solutions to this?

TIA

<guevara_81 (AT) yahoo (DOT) com> wrote

One possible solution could be to check DATABASEPROPERTYEX('MyDB', 'Status')
either before executing the package or within the package itself - if it
isn't online then you can wait for an appropriate period of time and try
again.

Simon

Thanks! That's a HUGE help.

thanks again.

-A