Hi,

Thanks for the help. I found a solution. Actually, variable that needs to be used for XML configuration was not set correctly. Now it is working fine.

Thanks and Regards,

Samit Shah

Hi,

Thanks for the reply.

Order is XML and SQL Server Package Configuration. Also it picks the correct path to load XML file, as when I open the solution, it shows correct...

Hi Kreecha,

Did u received solution on how to load the 500+ tables with update/insert/delete? If yes, then could you please let me know, how did u worked out that.

Thanks and...

Thanks Koen and Bru.

I have already created incremental load for 1 table using merge join. I am thinking to make it generic, so that I dont have to write dataflow...

Thanks Bru.

Any suggestions on how I can do it?

We have requirement to do it through SSIS, since we need to log inserted, updated, deleted records.