Step 8: Test the Solution
In this step, we test the solution by dropping a flat-file message to a folder on the FTP Server. The XML 一方向ブリッジ should consume this message, process it, and then insert the values into the OrderDetails table in the Orders database of a SQL Server database.
To send a message to the bridge
Locate the Orders.txt message from the location you downloaded the FTP_EAI_Tutorial sample and copy it to a folder on the FTP Server. The ブリッジ you configured as part of the BizTalk サービス プロジェクト must be configured to pick messages from this folder. The Orders.txt message has the following content:
Wait for the message to disappear. Now go to the OrderDetails table in the Orders database and verify if the new values have been inserted.
Note that the values correspond to the data in the flat-file message that you dropped to the FTP server.
Because you configured the ブリッジ to track message properties, you can also view the tracked data. To do this, go to the BizTalk サービス ポータル registered for your BizTalk サービス subscription, click the Tracking tab, click the Route: Route activity information, and then from the command bar, click Details. In the pop-up window, notice that the OrderId and TotalAmount properties are tracked and their values are also displayed.
Note that the tracked values correspond to the values that are inserted into the SQL Server database.