Hi All,
I'm new to this forums and found good information on this.
Hoping that I will get a help on the below requirement I have within the SSIS package.

I have created an SSIS package and below are the high level steps.
1-Delete the destination data from the Sql Server table(Using Execute Sql Task)
2- Extract data from Source (oracle) to Destination Sql Server using a sql query(using Data Flow task)
3- The data from destination table is extracted by executing the stored proc and the contents are saved to a text file (usinf Data Flow task under which OLEDB source and Flat File destination)
4-The above text file is loaded to another oracle database using the batch file which has the step to create the log file and save it on file share(using Execute process task).
5- I would like to read the contents of above log file into a variable and this variable will be sent to the main to send the mail with that file content..

Can you please with the VB code to accomplish the 5th step(Read the file contents into a variable).
Thankyou.