Hi Elliott,

Thanks for the reply. I understand, when we speak about using OLEDB command, evidently there would be performance bottleneck. I am right now not sure about the amount of...

Thanks Alex for the solution. Its working 🙂

After getting all the error rows just keep an aggregate transformation task.

Do a group by on all the three fields in the aggregate transformation task (Just check the column name...

Could you please post the exact error message you are getting? Get the error message either from the Job history or from the log file /the log table if you...

Hi,

Just type services.msc in RUN command and go to SQL Server Agent Service and then right-click properties.

There, go to the tab "Log On". Chevk if it is running on...