thanks jiff....how can we do the same with out using identity or cursors i.e by just using while loop and update.....i missed telling this in my previous post

Another work around would be..u just move the Server1 table to server2...update the server2 table and then delete the copied table on server2

Here u mean to say that if u have 10 records in an excel sheet only one record is getting transformed to destination database table? and also could u bee...

Yes, u can just put this code in activeX script in DTS package and assign the global variables "FilesFoundMail" and "FilesNotfoundMail" to execut SQL task using dynamic properites task. And...

No luck!!..it didn't work

Here is how my package looks

1) create a new source object

2) create a new destination object.

3) create a answer delete local task

4) create a update source record task

5)...

for this first u need to declare to Gloable variable StartDate and EndDate for taking the date range and the u can use the follwing code in the activeX script...

Thanks for all those clarifications. I have piece of code VB script which take care of auto mapping, the problem here is it's not working in loop.

As u mentioned...

yes, that can be done. what if i need to transform the tables to a text file. In this case i need a script that do auto mapping for each...

yes, evrything remains the same.