BizTalk Server Orchestration - SQL Adapter confusion. [asking for suggestions and/or documentational references]

Author

SQL Adapter confusion. [asking for suggestions and/or documentational references]

RedStain

2006-06-08, 1:19 pm

I am looking for examples and walthrough for usage of SQL Adapters.

SETUP
I am using sharepoint in this solution and this is what I have already
got setup successfully.
I get an infopath document which is written to one folder by a person.
I have an Transform shape which deposits the document(modified) into
another document folder.

PROBLEM
1) I need the orchestration to assign and 'stamp' the document with a
(unique and sequential) serial number into it as it drops it into the
destination. I assume this will have to be read from a database to keep
track of the number.
2) I am ok with SQL but I am unused to the implementation of the SQL
adapter. Does anyone know where I can find webcasts or documentation on how
to set this up [read and write operations].