I had attended a interview.In interview i have faced this questions please help me to resolve the queries.
1.We have 5 csv files,how can send data from csv files to single destinations.
2.We have 10 csv files in the folder,file names are having 6 letters lenth,first two letters represents the country code like US,UK.. and next two letters having like numerics like 10 to 99 and next two letters represents quarters like Q1,Q2,Q3,Q4.totally file name like UK44Q2.csv
3. How can validate the file name should be in same order or not,if file name not in the same order then it will be give an error.
4. How can develop this scenario.
In ssis package if we load 1000 records in to destination, then how can u send mail to project lead that mail containing information like 1000 records loaded or 2000 records loaded like that depend up on no of records loaded.
5.we have 10 csv files ,how can store the file names in to table
6.How to eliminate invalid characters for transfer data from txt file to sql table?