Adapters

Using output parameters with SQL Adapter
There is no support for output parameters when using the SQL Adapter.
Accessing remote files with the File Adapter
The File Adapter expects that the remote location has given access rights to the user account running the file receiver/transmitter.
For a receive location, the user account need read and delete access from the receive location, as well as query the contents of the folder.
What permissions do you need to read files using the File Adapter?
You need to have read and delete access on the folder and files, as well as query the contents of the folder.
When write a file using File Adapter, how is it locked?
When the file adapter write a file to disk it places an exclusive lock on the first byte, to prevent two BizTalk systems from trying to write at the same time. However, if you lock a range outside of the first byte, it will succeed.
This means that if another application is reading files in the same folder you need to ensure that the application only read files that it has exclusive access to/lock on.