February 3, 2009 at 9:59 pm
I have insert values from source to destination, where if destination contains the rows already for the given column value, it should delete those values in the destination and then , insert the values in the destination.
I have used oledb command between source and destination.
Where in source I have given a sql command like, select * from table where datevalue between '1/1/2009' and '1/2/2009'
I'm passing date values as parameters.
In oledb command I'm deleting i.e, delete from table in destination.
then, I am inserting into the destination table.
Problem, here is as soon as the control reaches oledb command, it is not executing further.
It takes very long time to execute.It is in yellow color only for long time.
Can u plz suggest me how to do it efficiently using oledb command, or else suggest some other way to do this task.
Thanks.
February 3, 2009 at 11:11 pm
Use an Execute SQL Task (in the control flow) to delete the rows before you start the Data Flow Task.
Using the OLE command deletes 1 row at a time that is why it takes so long.
February 4, 2009 at 1:35 am
Thank you. 🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply