SQL Server Import Job Removed Data After Job Failed
Take a good look at the control flow, both in your SQL Agent job, and the SSIS package it's running. I suspect there's a step in one of them that cleans out the source table after the work is finished, and this step is running regardless of whether the import succeeded or not.

Or there may be an unrelated cleanup job that cleans out that import table.