Loading data (500 million rows) interactively using SSDT from source (Teradata) into (SQL2014) destination table.
Notice load process is not continuous since SPID in sp_whoisactive appears in short burst when INSERTING, then same SPID viewed via sp_who2 alternates between (SLEEPING, DORMANT, INSERTING).
Shouldn't the E2E process be continuous, no breaks, just continuous INSERT? Could it be SSDT loading data piece-meal/or the source doing it/or for some reason I have not encountered before sql server is loading the data in batches?
Any ideas of what I'm experiencing would be greatly appreciated.