Inserting / Reading binary data with the SQL adapter?

This topic has 3 replies, 1 voice, and was last updated 9 years, 3 months ago by community-content.

Viewing 2 reply threads

Author

Posts
- December 7, 2006 at 5:47 AM #16772
  community-content
  Hi!
  
  Is this at all possible?
  
  I need to insert binary data (compressed txt) in order to archive messages in a SQL dB? any advices?
- December 17, 2006 at 11:10 AM #16967
  community-content
  I’d probably go about this using .net code inside an Orchestration – for insertion at least.
  
  Otherwise, have you taken a look at: http://www.biztalkgurus.com/samples/SQL-XML-Data-BizTalk-2006.html This should be able to process any type of data, just make sure you use the pass though pipeline.
  - December 17, 2006 at 7:59 PM #16972
    community-content
    You might also like to check out this custom SQL BLOB Adapter
    
    http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=189360ED-B216-45D2-B11A-B42828A3697D
- September 5, 2008 at 1:26 PM #20613
  community-content
  hi, I know this was a long time ago but do you remember how you ended up doing the binary insert? I need to do the same for images. I’m using the SQL Adapter in BizTalk server 2006 to call the insert stored procedure. Thanks! Evie
Author

Posts

Viewing 2 reply threads

The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.