• BULK INSERT on Windows OS is not pipelined : first you need to save all to a file, then Bulk Insert from the file.

    SSIS use C# to achieve pipelining .