I want to run a test first to see how "fast" it can show the result. I tried both options, but it is still slow.

i used the Tally table and...

YES

I did this but still take a long time.....

Okay.. I just reviewed my new database and I see that the Second File Group is offline, same thing with the tables that are located in the Second File Group....

Thank you

it works exactly like that. It was an error in the original Flat Files.. we re processes them and everything works fine.

Regards,

I try them as well.. and nothing... :crying:

you are absolutly right!!

I think the right expression for a Derived Column is:

luaDate == "0" ? (dt_dbtimestamp)"1900/01/01" : (dt_dbtimestamp)luaDate

but Im getting this error:

The conditional operation failed.

SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. ...

I found the answer. It was easier that I thought.

in a Derived Column use this:

REPLACE(luaDate,"0","1900-01-01")

THAT'S ALL... lol

good luck!

Thank you all !!

I have been reading about it. I will need something historical and I need to know what changes were made on my tables. I will keep doing...

HI Adam,

Thank you for your comment. Yes I was sarcastic and I apologize for that, I think Steve was nice and clear with his answer after my last post.

I...

Geez! you are really a pain... lol

I just was trying to define one backup from another.. Seems like you are a guy that goes with the book... anyway!, I guess...

Yes I do understand that. I actually know that the sync is out of date because both log backups. and the Restore wont "pick up" any .trn file.

The only thing...

Yes I can do it.

I was thinking in the case of my Server where the LogShipping is been placed (the standby database) crashes. Then I wont have a way...

Yes, you can have a StandBy database. This is very common in Log Shipping, the database is read only and it can help for reporting or queries. This mode is...

Error says that the secondary database is skipping the transaction logs as it already applied them.

You should check the copy, restore and alert timings of the database..maybe they are not...

Actually, this is the complete log summary for the last restore:

Message

Microsoft (R) SQL Server Log Shipping Agent

[Assembly Version = 9.0.242.0, File Version = 9.00.1399.00]

c Microsoft Corp. All rights reserved.

2010-07-20 14:45:00.22-----...