thanks journey man,

the problem is that i need to automate this process and it needs to run at night. the problem i am getting is when i use the...

actually ..no worries, i have a solution that works. i bring in the data from flat file to sql (staging Table)table, then do the updates and inserts using tsql.

thanks for...

actually ..no worries, i have a solution that works. i bring in the data from flat file to sql (staging Table)table, then do the updates and inserts using tsql.

thanks for...

ave tried that but because the source is flat file and it is an update, when i am writing the sql statement, i dont know how to spcify the source...

Thanks a lot guys!!!. i will try both suggestion .

a big thanks to every one that has responded

Thanks, i will do just that