Store contents of text file in object variable

Question

HI.

I have a textfile, which contains 40+ sql statements. I would like to read the text file and store in a Object variable in SSIS.

How to achieve this ?

Thanks

Answer 1

Hi @venkatesh padmanabhan ,

We can transfer data from Flat File Source to Recordset Destination in SSIS Data Flow Task.

Please refer to the following links:

1. Use a Recordset Destination
2. RecordSet Destination 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.