Loading files ( CSV different structures) using SSIS

Mav 81 Reputation points
2020-08-25T04:38:04.257+00:00

Hi,
I have 5 different files with different columns and I would like to load them into SQL tables via SSIS.
I have the option of writing 5 dataflow tasks. however is it possible to load them dynamically with just 1 dataflowtask

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,502 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 42,761 Reputation points
    2020-08-25T10:10:53.103+00:00

    dynamically with just 1 dataflowtask

    SSIS isn't that dynamically, you have to fix define the data source for each CSV file with matching data types, same for the data destinations.

    1 person found this answer helpful.
    0 comments
  2. Monalv-MSFT 5,896 Reputation points
    2020-08-25T06:08:32.217+00:00

    Hi AshishNZ,

    We can use just one Data Flow Task , and then drag 5 Flat File sources and 5 OLEDB destinations.

    One source or one destination can only read one type of structured metadata.

    Please refer to the following links and pictures:

    Multiple streams

    Populate external metadata columns

    20008-df.png
    20046-5sources5destinations.png

    Best Regards,
    Mona

    ----------

    If the response is helpful, please click "Accept Answer" and upvote it.

  3. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more