I'm doing a migration from Oracle to SQL Server and, for one of the tables where we have 3 million records, it is taking a lot of time to complete.
When I check the activity monitor, I can see the a wait type of
PREEMPTIVE_COM_SEQSTRMREAD. Please help me understand what could be the issue.
I'm using linked server to connect Oracle from SQL Server.