Thanks Krishna.

That was for dynamic filtering using <>HostNames. My issue is different with all 3 DB servers running sql 2005 SP3.

Got some help at

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/c0316233-380d-4dda-8650-e34e125a690a

Got some help at

http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/c0316233-380d-4dda-8650-e34e125a690a

Thanks Steve... That should solve my issue.

I understand it might be really simple for some of you , but i tried googling online and all the hits were using "select * from dtproperties" which doesn't work...

Sounds Kool... Thanks i would definetely try using this

Thanks a lot for the fast reply. I was checking in the Performance - Object Execution Statistics Report in SQL 2005, & as you said IF Exists was doing better...

Thank you. I will try to implement if not exists. Another one which one is faster IF EXISTS or IF NOT EXISTS...

Thanks for your response Lynn. I think i need to do some web/forum mining and am sure i'l find some one who has faced this issue and posted it. Thanks...

The packages are still in Legacy DTS. Can you please let me know how can we set the batch size in DTS. The packages are under Management-Legacy-DTS.

DTS package.... As the source is not MS SQL, we truncate the tables in the destination and load the data

What i understand is break the import into multiple small packages, so that it is not a single big transaction on a whole, but a number of small transactions. i'l...

I am not an expert but believe from what i have learned is that a recovery should start with the full backup. I hope the pro's visiting this forum should...

Thanks a lot for your advice Noel.

The tables from both the servers are totally independent of each other as they are data from DB's catering to different needs. I thought it would be great to have...