I have a ssis package where it reads a folder with csv files and transform those files into sql server table. at the same time those csv files are moved to an archive folder. If there is any file with wrong extension or file format against the defined sql server table, it is moved to another folder named error folder. I need to conduct unit testing to this package and validating the file format against the table without using any external tools.
What I have tried:
I have completed the extracting data and loading data into the sql server table,moving the csv files corresponding to the table into the archive folder and file with the wrong extension to the error folder.