Store contents of text file in object variable

venkatesh padmanabhan 181 Reputation points
2020-10-27T12:17:07.107+00:00

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,705 questions
0 comments No comments
{count} votes

Accepted answer
  1. Monalv-MSFT 5,926 Reputation points
    2020-10-28T02:00:33.653+00:00

    Hi @venkatesh padmanabhan ,

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

    35514-df.png

    35554-recdes.png

    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.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.