如何使用SSIS向指定的excel 名为test1的sheet中导入数据库中表的数据?

m 4,271 Reputation points
2023-10-31T09:33:58.44+00:00

User's image

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

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,341 Reputation points Microsoft Vendor
    2023-11-01T06:58:55.3866667+00:00

    Hi @m

    For information on using SSIS to import data from Excel or export data to Excel, you can check out this document: Import data from Excel or export data to Excel with SQL Server Integration Services (SSIS).

    Here is a blog that uses SQL Server Integration Services to export SQL Server data to an Excel worksheet: https://www.mssqltips.com/sqlservertip/5324/export-sql-server-data-to-multiple-excel-worksheets-using-sql-server-integration-services/. Maybe you can use it as a reference.

    Hope these can help you.

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya