Issue: SSRS reports are showing duplicate records(comparing to old-migrated server).
Troubleshooting/Background -Data is being pulled from a flat file vis SSIS jobs.
-Each job runs 1 time successfully in SSMS. If a job fails, the records in SSRS will not duplicate. This makes me think the SSIS Jobs are running a second time out of view.
-I initially thought the packages might be pointing to the old server so I verified each package's data connection in visual studio.
-I have also since shutdown the old server and the data is still duplicating.
Any suggestions on how to fix this record duplication issue?
