In my dataflow i have one OLEDB source and destination connection, i am executing a sp with 2 parameters(fromdate & todate) and inserting the result set to one table using OLEDB destination, it is taking 2 hours to complete.
but when i am using query instead of sp in the OLEDB source it has executed in 2 min.
Why..? what i need to change if it has to execute through SP.?