Use SSIS Bulk export

Luigi Pellico 1 Reputation point

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,509 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Yitzhak Khabinsky 25,726 Reputation points

    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 No comments

  2. ZoeHui-MSFT 34,996 Reputation points

    Hi @Luigi Pellico ,

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


    Zoe Hui

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

    0 comments No comments