Potential issue with DTS and Log Shipping

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@.yahoo.com> wrote in message
news:1104855148.496261.221680@.z14g2000cwz.googlegr oups.com...
> 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

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