MountJohnny
Technical User
Hi All,
I'm in the process of atempting to transform some HL7 messages via Biztalk 2002 to make inserts and updates to a SQL Server
On my biztalk port, I’m using the AICSQL SQLPipeline as the primary transport. In my channel setup, I'm going to the "Advanced" settings on the last page of the channel config and specifying the SQL server, login, database.
My question is , how is the data actually getting to the SQL database on the other machine. Am I sending an XML file? Also, I have know idea how to specify what table in the SQL I’m aiming at. For the destination schema in my transformation map, I'm using a Microsoft canned version that came with the AICSQL tutorial.... are the block01, block02 the actual tables?
Can anyone give me a hand with this? The documentation on this config is vague at best.
Many thanks,
John
I'm in the process of atempting to transform some HL7 messages via Biztalk 2002 to make inserts and updates to a SQL Server
On my biztalk port, I’m using the AICSQL SQLPipeline as the primary transport. In my channel setup, I'm going to the "Advanced" settings on the last page of the channel config and specifying the SQL server, login, database.
My question is , how is the data actually getting to the SQL database on the other machine. Am I sending an XML file? Also, I have know idea how to specify what table in the SQL I’m aiming at. For the destination schema in my transformation map, I'm using a Microsoft canned version that came with the AICSQL tutorial.... are the block01, block02 the actual tables?
Can anyone give me a hand with this? The documentation on this config is vague at best.
Many thanks,
John