I have an ssis package which processes retail sales file. I have absolutely no issue with the package as it is running fine.
The issue i have is
every monday I receive a csv file from the client which has Friday, sat, and Sunday dates. So I have to manually go into excel and split the csv file into three csv sales file .
unfortunately the big file needs to be split into three and then the file needs to be processed one by one
This step is manual. can these be handled in ssis and be automated. so rather than me manually splitting the big file into three with three separate dates i want ssis to do that.
was thinking about this logic
conditional split - to check if the date is a monday
have three separate variables which will store dates
and then have some kind of lookup which will map the three dates with the big file.
would this be a right logic.. if not can anyone of you suggest an easy way of making this simple, if this sounds complicated