Almost every single morning, I have a tab delimited file with over 800K records. I need to load it into my database. This is the process:
- Get file from local or FTP
- Delete the old file which doesn't exist anymore in the database
- Insert only new records in the database
- Don't overheat SQL database.
How should I approach this? Is SSIS the right way to go?
September 25, 2013 7:35 PM