latest Post

Converting Blob Column to string in SSIS Script Component.

Recently I found myself needing to work with blob columns when transforming CRM data with SSIS. Specifically I was wanting to query and interrogate "Plugin Trace Logs" and output a daily email of any plugin errors to help the team become more proactive rather than reactive. 

Using the below fetch query and the Kingswaysoft CRM Source component.  I noticed the multi line text fields mapped to the SQL data type "ntext".


When reading this value from the data flow buffer in a SSIS Script component the "ntext" column actually returns the data as a "BlobColumn" and  in order to get the text string of the data in the column I had to use the GetBlobData() method in the DTS.Pipeline namespace.

After a bit of investigating I was able to convert the blob text to a string to be able to read the returned value and manipulate the data how I wanted. 

 The below snippet is the code I used.  Hopefully, this will help someone out.

Recommended Posts × +

18 comments:

  1. This comment has been removed by the author.

    ReplyDelete
  2. Very informative post! There is a lot of information here that can help any business get started with a successful social networking campaign. 増田裕介

    ReplyDelete
  3. How To Get Your Ex Lover/Partner/Boyfriend/Girlfriend/Wife Or Husband Back

    I was married for 16 years to a loving mother and wife. We had 2 children together who are now 11 & 13. I reconnected with an old girlfriend from college on Facebook and we began an affair and I left my wife. The woman I had an affair with is a wonderful woman and I love her too and our kids had begun accepting the situation and my wife has kind of moved on, but not in love with the man she is seeing. I thought I fell out of love with my wife and I felt terrible about what I did to her - she is a good woman and I don't know what came over me. I decided to try and get her back and I was recommended to Lord Zakuza for help to get reunited with my wife and within 48 hours after I made contact with Lord Zakuza my wife decided to work things out with me and now we are back together with our children living as one happy family. I really don't know the words to use in appreciation of what Lord Zakuza did for me but I will say thank you sir for reuniting I and my family back. For those in trying times with their marriages or relationship can communicate with LORD ZAKUZA through the below informations.

    Website via: lordzakuzaspells.com
    WhatsApp/call/text: +1 740 573 9483
    Email: Lordzakuza7 @gmail. com

    ReplyDelete
  4. my partner and I have been trying for a baby for over two years now, We were going to a fertility clinic for about 5 months before somebody at baby center told us to contact this spell caster who is so powerful, We contacted him at this email; babaka.wolf@gmail.com or Facebook at priest.babaka , for him to help us, then we told him our problem, he told us that we will conceive once we follow his instructions ,but after two years of trying we were at a point where we were willing to try anything. And I'm glad we came to Priest Babaka, Because his pregnancy spell cast and herbal remedy help us, and I honestly believe him, and his gods really helped us as well, I am thankful for all he has done. contact him via email: babaka.wolf@gmail.com or Facebook at priest.babaka if you are trying to have a baby or want your lover back. he has powers to do it, he has done mine

    ReplyDelete
  5. I really want to thank Dr Emu for saving my marriage. My wife really treated me badly and left home for almost 3 month this got me sick and confused. Then I told my friend about how my wife has changed towards me. Then she told me to contact Dr Emu that he will help me bring back my wife and change her back to a good woman. I never believed in all this but I gave it a try. Dr Emu casted a spell of return of love on her, and my wife came back home for forgiveness and today we are happy again. If you are going through any relationship stress or you want back your Ex or Divorce husband you can contact his whatsapp +2347012841542 or email emutemple@gmail.com website: Https://emutemple.wordpress.com/ Https://web.facebook.com/Emu-Temple-104891335203341

    ReplyDelete
  6. i want to say hallelujah to lord for using Priest Babaka of babaka.wolf@gmail.com to bless my womb, i have been married for the past 10year without a child i have look for all kind of help that can make me get pregnant but nothing works, but through an insight i came across Priest Babaka profile at the internet when i was searching for help on how i can get a baby, Quickly i contacted him to help me out, he said he will cast a spell that will make me sleep with my partner and get pregnant so he said he need to buy some of the other items he will use in casting the spell from the market that he want me to send him the money he will use in buying the items so i gave him the money and he cast the spell for me and ask me to go and lie with my partner so i did to my greatest surprise i became pregnant after that week so with so much joy in my heart i want to share this out to everyone in need that i have found favor in the hands of Priest Babaka of babaka.wolf@gmail.com, contact him now to via email : babaka.wolf@gmail.com or Facebook at priest.babaka

    ReplyDelete
  7. Wonderful article. Fascinating to read. I love to read such an excellent article. Thanks! It has made my task more and extra easy. Keep rocking https://movietube.video

    ReplyDelete
  8. Pretty nice post. I just stumbled upon your weblog and wanted to say that I have really enjoyed browsing your blog posts. After all I’ll be subscribing to your feed and I hope you write again soon https://thecouchtuner.space

    ReplyDelete
  9. I have a hard time describing my thoughts on content, but I really felt I should here. Your article is really great. I like the way you wrote this information https://couchtuner.quest

    ReplyDelete
  10. I found that site very usefull and this survey is very cirious, I ' ve never seen a blog that demand a survey for this actions, very curious https://soap2day.shop

    ReplyDelete
  11. Great job for publishing such a beneficial web site. Your web log isn’t only useful but it is additionally really creative too. https://soaptoday.website

    ReplyDelete
  12. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. From the tons of comments on your articles, I guess I am not the only one having all the enjoyment here keep up the good work https://solarmovies.space

    ReplyDelete
  13. Remarkable article, it is particularly useful! I quietly began in this, and I'm becoming more acquainted with it better! Delights, keep doing more and extra impressive https://soaptoday.space

    ReplyDelete
  14. Remarkable article, it is particularly useful! I quietly began in this, and I'm becoming more acquainted with it better! Delights, keep doing more and extra impressive https://theprimewire.site/

    ReplyDelete
  15. I'm just too happy that everything is in place for me now. I would gladly recommend the use of spell to any one going through marriage problems and want to put an end to it by emailing Dr Emu through emutemple@gmail.com and that was where I got the help to restore my marriage. WhatsApp +2347012841542
    Https://web.facebook.com/Emu-Temple-104891335203341

    ReplyDelete
  16. This comment has been removed by the author.

    ReplyDelete