Loading files ( CSV different structures) using SSIS

Mav 86 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
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,631 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.

    Was this answer helpful?

    2 people found this answer helpful.
  2. 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

  3. Monalv-MSFT 5,926 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.

    Was this answer helpful?

Your answer

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