SSIS - data flow task - excel destination

nononame2021 256 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.
2,643 questions
0 comments No comments
{count} votes

5 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 40,586 Reputation points
    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.

    0 comments No comments

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

    how to setup in excel destination in stat flow task?


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

    data flow task


  4. nononame2021 256 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 256 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.?


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.