Received a “System.NotImplementedException” in custom pipeline component

While developing a custom pipeline component I began receiving a System.NotImplementedException when testing the pipeline from an Isolated Host.

After a bit of research, we found the following:

http://www.biztalkgurus.com/forums/p/11372/22514.aspx

Turns out the problem originates from the Http Adapter, which implements the Setter on the MessagePart.BodyPart.Data property, but not the Getter.

The solution was to change the code that retries the message stream from using MessagePart.BodyPart.Data to using MessagePart.GetOriginalDataStream().

Adding a Sql user that already exists

Occasionally I’ll need to copy a database over to my dev machine in order to be able to work offline.

USE <Target_Database>
EXEC sp_change_users_login 'Update_One', '<Server_User>', '<Database_User>'

This will re-associate the Server Login with the specified Database Login.