need assistance on some ssis logic

Question

Hi All

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

Regards
Farhan Jamil

Answer 1

Hi @Farhan Jamil ,

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

Yes, it was a reasonable logic.
Could you please share some example data?
Please refer to the following links:
1.SSIS Conditional Split Transformation overview
2.An Overview of the LOOKUP TRANSFORMATION in SSIS

Best regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.