I would like to use something that is provided by Microsoft SQL without creating by self .

any help will be very appreciated.

thank

I used several time bcp so I know that it must be run in cmd shell with xp_cmdshell,

I tried also Bulk insert it runs on 32 bit but has...

Hello,

the database was built years ago by others people, tables to be check are +/- 100.

I cannot modify anything about this database and anyone cannot modify the application.

I was asked...

Hello,

thank to everybody.

My problem is that there are lots of tables and only updated and new data must be moved to the destination tables.

To detect any changes or insert row...

Hello,

I have not tested it yet, but agreed with you, the only problem is that triggers are not only on 1 table but on lots of table, this may affect...

The,I will test it and I inform you about that

Thank

Hello,

my triggers is little bit different, but produce the same result.

I' ll try to modify them following your example just to see any increasing in performance.

About cursor or triggers they are not...

Hello,

days ago I applied both solution together: "<>" and Triggers.

Appliyng "<>" is good, performance increase a lot.

Triggers as well.

But when I tried them in test machine, the application that make continuosly update...

Hello,

I have tried to add <> for columns in the UPDATE statement, it looks like faster, but you say that can affect CPU.

Affecting CPU can affect other operation on server...

hi,

thank all for your contribution.

Yes, the truncate table that I have already thought may be another solution.

Hello,

thank for your reply.

The solution works fine.

Question:

Making ''Delay Validation' property' as true in case of modification of package they are in any case saved.

Any other problem is detected with the...

Thank everybody,

I wiil try your suggestions.

Hello,

already done for replication, but some tables have problem, so we decided another way.

I will try your suggestions

Thank

Hello,

thank for your faster reply.

I thought the same with trigger.

Interesting the solution on Where condition.

Back/restore is not useful because the destination db has more tables than the source.

Thank

Hello,

I am new in SSIS.

Could you tell me how to explain how to create a environment variable which tells SSIS where your config files are.

Config file is already done.

Thank