Hello Everyone,
How's Everyone doing? I hope all is well.
I have CSV file with a million rows that I need to split into 4 tables(250,000 rows to one table) and I can use your help. I want to use SSIS to upload the CSV file(split 4 ways) into 4 different tables). Can anyone help me with this please; Do I use a conditional split? And if so, what will be the expression written?
All ways to do this is appreciated.
Thanks in advance!