For information on this example, please go to:
http://objectsharp.com/blogs/matt/archive/2005/10/23/3525.aspx


Prerequisites:

1) VS2005 with BizTalk 2006. 
2) Sql 2005 instance to do the Bulk Insert.


Note: The SqlBulkInsert Adapter was originally created in VS2003, but the code was ported to 
VS2005/BTS2006. It is possible to back port the code to VS2003/BTS2004.

To install:

1) Unzip the BTSBulkLoad.zip file on the root of your c: drive.
The following folders should be created:

C:\BTSBulkLoad\Bindings
C:\BTSBulkLoad\BTSForTesting
C:\BTSBulkLoad\Files
C:\BTSBulkLoad\Sql
C:\BTSBulkLoad\SqlBulkInsertAdapter

2) Using Microsoft Sql Server Management studio, create a database called:
BTSSqlBulkLoad

Note: The initial size of the Datafile should be approx 200 MB.

use the scripts in the C:\BTSBulkLoad\Sql\Scripts folder to create:
i) Table InsertNewProductionOrders -> Table_InsertNewProductionOrders.sql
ii) Stored procedure LoadInsertProductionOrders ->  SP_LoadInsertProductionOrders.sql

3) Rebuild the Adapter Project. 

Open the C:\BTSBulkLoad\SqlBulkInsertAdapter\SqlBulkInsertAdapter.sln 
and Rebuild the solution.


4) Register the adapter

Double click on the C:\BTSBulkLoad\SqlBulkInsertAdapter\SqlBulkInsertAdapter.reg 
file to register the adapter.

5) Add the Adapter.

Using the BizTalk 2006 Administration Console, Navigate to the Adapters node and add a new
adapter. Choose the SqlBulkInsert Adapter from the dropdown and name it the same -> SqlBulkInsert 

6) Restart the BizTalk Host instance.

7) Create a new Application.

In the BizTalk Administration Console, create a new Application called :
DemoSqlBulkLoad

8) Build the BizTalk Test Solution:
Open up the C:\BTSBulkLoad\BTSForTesting\BTSForTesting.sln. 
Rebuild and then deploy.

Note: In the Configuration properties for the BizTalk project:
Change: Configuration Properties -> Deployment -> Configuration Database from SQL2005-IDW14\SQL2000
to the correct Server, for deployment

9) Install the binding file:
Using the BizTalk Administration Console, navigate to the  DemoSqlBulkLoad application (created above),
right mouse button and refresh and then import the Binding file -> C:\BTSBulkLoad\Bindings\ReceiveAndSendPorts.xml

The following should be created:

Two Send Ports should be created:
SqlBulkInsertSendPort
FileFlatFileSendPort

Two Receive Ports:
SqlBulkInsertReceivePort
FlatFileReceivePort

Two Receive Locations:
SqlBulkInsertReceiveLocation
FileFlatFileReceiveLocation


10) Start the application
Right mouse button on the DemoSqlBulkLoad application and then Start.
All Receive Locations and Send Ports should be enabled/started.

11) Check Receive Location -> SqlBulkInsertReceiveLocation
Double Click on receive location -> SqlBulkInsertReceiveLocation 
Click on the configure button. Ensure that the SqlConnectionstring is correct for your 
Sql 2005 instance.

12) Test

Pipeline processing test:

First copy the file -> C:\BTSBulkLoad\Files\TestFlatFile.txt 
to folder:
C:\BTSBulkLoad\Files\ReceiveForPipelineProcessing

After a few minutes an XML file should appear in folder:
C:\BTSBulkLoad\Files\SendForPipelineProcessing 

The size of this xml file should be approximately 213MB

-----------------------------------

SqlBulkInsert Adapter processing test:

First copy the file -> C:\BTSBulkLoad\Files\TestFlatFile.txt 
to folder:
C:\BTSBulkLoad\Files\ReceiveForSqlBulkLoad

After a minute or so a small XML file should appear in folder:
C:\BTSBulkLoad\Files\SendForSqlBulkLoad

Perform the following query:
select count(*) from dbo.InsertNewProductionOrders

The result should be 224130, but may be doubled due to a bug.