Hi Team - In SSIS, I have created a task to create a file. The destination is a text file. The file is created in the Stage folder.
So, Now from the Stage folder, I want to read the file. If the file in the Stage folder (which I created above) has a record count of 1 or greater than 1 record then move to another folder i.e Final Folder.
Could you please me out on how I do that? Thank you in advance.