Use SSIS Bulk export

Luigi Pellico 1 Reputation point
2022-11-14T14:34:25.287+00:00

can I use bulk export command in SSIS like SqlBulkCopy class?
I need to use in ssis a function bulk to export a lot of data from a table.

Can I do this?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,079 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 21,511 Reputation points
    2022-11-14T20:37:44.793+00:00

    Hi @Luigi Pellico ,

    You can use SSIS Execute Process Task to launch bcp.
    That would be the most performant way to do it.

    Check it out here: using-bcp-utility-in-ssis

    0 comments
  2. ZoeHui-MSFT 22,061 Reputation points
    2022-11-15T02:53:17.52+00:00

    Hi @Luigi Pellico ,

    You may also refer to sql-server-bulk-copy-and-bulk-import-and-export-techniques

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments