SSIS - data flow task - excel destination

nononame2021 246 Reputation points
2021-11-14T06:42:54.053+00:00

how to develop a flow to import a file to sql server table and output the table to excel (.xlsx)

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

5 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 18,896 Reputation points Microsoft Employee
    2021-11-15T03:00:24.607+00:00

    Hi @nononame2021 ,

    You may try with below to see if it could meet your need.

    The Multicast transformation distributes its input to one or more outputs.

    multicast-transformation

    149176-screenshot-2021-11-15-105708.jpg

    Noticed that you have raised a lot of issues in Q&A, if the issue has been resolved, don’t forget to click "Accept Answer" on the reply so that we could archive the case. : )

    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.

    No comments

  2. nononame2021 246 Reputation points
    2021-11-15T03:28:23.97+00:00

    how to setup in excel destination in stat flow task?


  3. nononame2021 246 Reputation points
    2021-11-15T06:55:11.007+00:00

    data flow task


  4. nononame2021 246 Reputation points
    2021-11-15T08:03:36.877+00:00

    I have added Ole db source to connect to sql server, and select table_a as source

    and then I add excel destination as destination and add excel connection which is th output path.

    after I choose the excel connection in excel destination, I don't know how to input the data access mode if I want to output table in sql server to local pc.

    how to set the data access mode?


  5. nononame2021 246 Reputation points
    2021-11-16T11:01:49.94+00:00

    hi how can I output excel file using the template
    I have a task to copy the template to output path, after that I need to add a flow in data flow task to export sql server table to excel destination

    i have created a excel connection and set the excel output path, on excel destination, I set it as connection, after that, there is no select on the table or variable name, what should I setup after inputting the excel connection in excel destination object.?