Creating 3 files in SSIS Package

him tim 1 Reputation point
2022-03-03T10:51:33.483+00:00

Hi,

I have a sample excel file and I am trying to create 3 different excel files using a SSIS package.

Sample File Name: ABC.xls

Required Files:
ABC_INV.xls
ABC_ALIAS.xls
ABC_ADDRESS.xls

I am able to create a single file using File Task option but how do I create all 3?

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

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 33,781 Reputation points
    2022-03-04T01:45:44.03+00:00

    Hi @him tim ,

    Check these two links about Create Multiple Files Dynamically which contain detailed steps.

    Hope they are helpful.

    ssis-how-to-create-multiple-files.html

    ssis-package-to-dynamically-create.html

    Regards,

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.

    0 comments No comments