SSIS - data flow task - excel destination

nononame2021 246 Reputation points

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

    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.



    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. : )



    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

    how to setup in excel destination in stat flow task?

  3. nononame2021 246 Reputation points

    data flow task

  4. nononame2021 246 Reputation points

    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

    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.?