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 × +

56 comments:

  1. This comment has been removed by the author.

    ReplyDelete
    Replies
    1. I want to let the universe know that I'm happy today because of Lord Masuka the spell caster who brought my husband back to me when I thought I have lost him forever. On a fateful day I saw series of testimonies on the internet about the help he renders to the heartbroken, so I decided to contact him about my husband who left me without a word, after I narrated all my problems to him he assured me that he's gonna come back home to me to some point I believe him and I did all he asked me to do to my greatest surprise my husband who had refused to see me came to the house and wept for forgiveness and now we are happily living together with much love and care from him. Do you have problems in your relationship ? Has your partner broke up with you and you still love and want him back? Do you have problems with your finances? Lord Masuka is the answer to all your problem, contact him on below email lordmasukaspelltemple@hotmail.com you can also visit his website https://lordmasukaspelltem3.wixsite.com/masuka? and contact him via Whatsapp +1(234)-307-0752

      Delete
    2. I NEED MY EX LOVER BACK TO ME EMAIL assurancesolutionhome@gmail.com whatsapp   +1(424)-261-8520
      I contacted DR LARRY and he told me that my ex will come back to me in the next 4days, DR LARRY released him to let me know how much I loved and wanted him. And opened his eyes to picture how much we have shared together. My ex is now back to me again. As I`m writing this testimony right now I`m the happiest Woman on earth and myself and my boyfriend are living a happy life and our love is now stronger than how it was even before our break up. All thanks goes to DR LARRY for the excessive work that he has done for me by helping me to get back with my ex boyfriend. I would like to drop DR LARRY website  http://assurancesolutioncenter.website2.me/     and hope you see this testimony and contact him if you have a lover that you really want back so badly, Email assurancesolutionhome@gmail. com or you can whatsapp him on this Number +1(424)-261-8520  assurancesolutiohome.blogspot.com 







      I NEED MY EX LOVER BACK TO ME EMAIL assurancesolutionhome@gmail.com whatsapp   +1(424)-261-8520
      I contacted DR LARRY and he told me that my ex will come back to me in the next 4days, DR LARRY released him to let me know how much I loved and wanted him. And opened his eyes to picture how much we have shared together. My ex is now back to me again. As I`m writing this testimony right now I`m the happiest Woman on earth and myself and my boyfriend are living a happy life and our love is now stronger than how it was even before our break up. All thanks goes to DR LARRY for the excessive work that he has done for me by helping me to get back with my ex boyfriend. I would like to drop DR LARRY website  http://assurancesolutioncenter.website2.me/     and hope you see this testimony and contact him if you have a lover that you really want back so badly, Email assurancesolutionhome@gmail. com or you can whatsapp him on this Number +1(424)-261-8520  assurancesolutiohome.blogspot.com 

      Delete
  2. I promise to share this testimony all over the world once my boyfriend returns back to me, and today with all due respect I want to thank DR.ONIHA for bringing joy and happiness to my relationship and my family. I want to inform you all that there is a spell caster that is real and genuine. I never believed in any of these things until I lost my boyfriend, I required help until I found a great spell caster, And he cast a love spell for me, and he assured me that I will get my boyfriend back in two days after the spell has been cast. Three days later, my phone rang, and so shockingly, it was my boyfriend who has not called me for the past 6 years now, and made an apology for the heart break, and told me that he is ready to be my backbone till the rest of his life with me. DR.ONIHA released him to know how much I loved and wanted him. And opened his eyes to picture how much we have shared together. As I`m writing this testimony right now I`m the happiest girl on earth and me and my boyfriend are living a happy life and our love is now stronger than how it was even before our break up. So that`s why I promised to share my testimony all over the universe. All thanks goes to DR.ONIHA for the excessive work that he has done for me. Below is the email address in any situation you are undergoing, it may be a heart break, and I assure you that as he has done mine for me, he will definitely help you too.
    EMAIL: ONIHASPELLTEMPLE@GMAIL.COM
    CALL/WHATSAPP : +16692213962.
    Website: http://onihaspells.com. 

    ReplyDelete
  3. I want to let the universe know that I'm happy today because of Lord Masuka the spell caster who brought my husband back to me when I thought I have lost him forever. On a fateful day I saw series of testimonies on the internet about the help he renders to the heartbroken, so I decided to contact him about my husband who left me without a word, after I narrated all my problems to him he assured me that he's gonna come back home to me to some point I believe him and I did all he asked me to do to my greatest surprise my husband who had refused to see me came to the house and wept for forgiveness and now we are happily living together with much love and care from him. Do you have problems in your relationship ? Has your partner broke up with you and you still love and want him back? Do you have problems with your finances? Lord Masuka is the answer to all your problem, contact him on below email lordmasukaspelltemple@hotmail.com you can also visit his website https://lordmasukaspelltem3.wixsite.com/masuka? and contact him via Whatsapp +1(234)-307-0752

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

    ReplyDelete
  5. 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
  6. 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
  7. I am so happy to share this fantastic testimony of mine. My life has changed round completely in 48hours. I can see myself in the mirror and smile. I have confidence in myself and my abilities for the first time in ages. I have my boyfriend back in my life with the help of Dr Oniha. He said sorry 24 hours after the spell was created. He said he realised that he never really wanted to break up and he could not handle emotional baggage I was carrying around all the time. He said that he thought he was the negative influence on my life and thought it best to leave. He said it was hard that I kept talking about the past all the time. We have both forgiven each other. I have money in my pocket that is my own at last. (My compensation cheque came through. I was told it was months away. I am living proof of what Dr Oniha can do. I thank you so much Dr Oniha for the wonderful thing you did in my relationship. I am so happy now. With your help we were both able to see and speak the truth to each other. I never thought a spell could help a couple before. I am very pleased to contact you and initiate all this to happen. Anyone who has a relationship problem can contact Dr Oniha.
    EMAIL:ONIHASPELLTEMPLE@GMAIL.COM
    WEBSITE http://onihaspells.com
    Call/Whatsapp number: +16692213962

    ReplyDelete
  8. I want to thank the great ONIHA for what he did for me. He brought happiness back into my life. My boyfriend left me and told me is over I was devastated as I loved him so much I decided to contact a spells caster and I met a friend who told me of a great doctor called Dr Oniha and I decided to contact him and he told me in three days my boyfriend will call me and beg me to accept him I thought he was joking, in three days everything happened as he said I am so happy now and grateful to you Dr Oniha. You too can also contact Dr Oniha for any kind of relationship problem he can also help you solve your problem.
    Email: onihaspelltemple@gmail.com
    Call/Whatsapp number: +16692213962
    Website: http://onihaspells.com

    ReplyDelete
  9. I don't know how to explain this.. I am overwhelmed with happiness, You say it and it comes to pass Dr Oniha..OMG! This is more like a miracle. You are a God sent to me..I love you and I will forever testify about your services to other people who are also facing marital problems. You make my whole life a living testimony. My Man is back according to your word. All thanks to you Dr Oniha. I will forever be grateful to you. Bless you! Bless you!! bless you!!! Anyone out there having similar problems in his/her marital home should contact this great spell caster he can be of help. Contact Dr Oniha on his website or email.
    onihaspelltemple@gmail.com
    CALL/Whatsapp number +16692213962
    Website: onihaspells.com

    ReplyDelete
  10. Very interesting article. Many articles I come across these days really not provide anything that attracts others, but believe me the way you interact is literally awesome. I will instantly grab your rss feed to stay informed of any updates you make and as well take the advantage to share some latest ongoing news, Fake divorce papers website on how to outshine your partner for a valid divorce papers or how to get a fake marriage certificate with legal documents. This Marriage system is widely used in the USA, UK, Australia and Canada presently by foreigners to obtain their full citizenship documents. l thought twice to bring this latest citizenship obtaining formula use by foreigners for everyone to be aware of. Thank so much for allowing me to pass this news to enlighten the public on what is going on around the world through your superb platform.
    Not over demanding, I will also take the advantage to ask for your permission to join our 179.3k members TELEGRAM GROUP
    to share with us your ideas or any latest update on your blog.
    Thanks I am Scott from Globex, we are expecting you on our platform.

    ReplyDelete
  11. DO YOU NEED A PERSONAL/BUSINESS/INVESTMENT LOAN? CONTACT US TODAY VIA WhatsApp +19292227023 Email drbenjaminfinance@gmail.com

    HELLO
    Loan Offer Alert For Everyone! Are you financially down and you need an urgent credit/financial assistance? Or are you in need of a loan to start-up/increase your business or buy your dream house. GET YOUR INSTANT LOAN APPROVAL 100% GUARANTEED TODAY NO MATTER YOUR CREDIT SCORE. WhatsApp:+19292227023 Email: drbenjaminfinance@gmail.com

    ReplyDelete
  12. 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
  13. I am so delighted I found your weblog, I really found you by accident,
    And would just like to say thank you for a fantastic post and a all round entertaining blog (I also love the theme/design), NEW TIPS TO IDENTIFY A FAKE DRIVERS LICENSE I don't have time to go through it all at the minute but I have bookmarked it and also added your RSS feeds, so when I have time I will be back to read a lot more, Please do keep up the excellent job.

    Y’all don’t forget to join this DMV EXPERTS TELEGRAM GROUP for more information about new drivers license and updated materials being used along the production process of the DL . You can also take advantage to learn and meet many Experts who will guide you on numerous techniques for anyone who love hacking and don’t know how to go about it .

    ReplyDelete
  14. 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
  15. I am the happiest woman on earth right now, My husband that left me a few months ago just came back to me last night crying for me to take him back. DR, WINNER is a true and real Psychics He brought back my husband” Here’s his content if you have any problem contact him on his Email him now: Winnersspellcast@gmail.com And you can also reach him on whatsApp +2348138289852 or via his website:https://winnersspellcast.blogspot.com

    ReplyDelete
  16. 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
  17. Thank you so much as you have been willing to share information with us. We will forever admire all you have done here because you have made my work as easy as  https://thecouchtuner.one

    ReplyDelete
  18. 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
  19. Thank you so much as you have been willing to share information with us. We will forever admire all you have done here because you have made my work as easy as  https://couchtunerweb.site

    ReplyDelete
  20. Exactly when was the last time you've perused a magazine and quickly wanted to get it and peruse it once more? It doesn't occur habitually. https://couchtuner.casa

    ReplyDelete
  21. 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
  22. I am impressed. I don't think Ive met anyone who knows as much about this subject as you do. You are truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Really, great blog you have got here https://couchtuner.rest

    ReplyDelete
  23. 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
  24. 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
  25. 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
  26. 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
  27. 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://1soaptoday.site

    ReplyDelete
  28. Thank you so much as you have been willing to share information with us. We will forever admire all you have done here because you have made my work as easy as ABC https://putlockers9.live

    ReplyDelete
  29. 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://watchcouchtuner.space

    ReplyDelete
  30. 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
  31. 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
  32. The world is filled with uncertainties, but obtaining a fake UK passport online is not one of them. 5 SIMPLE TECHNIQUES TO OBTAIN A VALID UK PASSPORT FOR TRAVEL PURPOSES Passports are important as they serve as a means of identification and also help you travel out of the country free from immigration restrictions.We have been online for a numerous years to help the movement between one country to another especially UK as most loved by many.

    ReplyDelete
  33. Keep up the good work; I read few posts on this website, including I consider that your blog is fascinating and has sets of the fantastic piece of information. Thanks for your valuable efforts. https://gostream.today

    ReplyDelete
  34. I am impressed. I don't think Ive met anyone who knows as much about this subject as you do. You are truly well informed and very intelligent. You wrote something that people could understand and made the subject intriguing for everyone. Really, great blog you have got here. https://freeinlinemovies.site

    ReplyDelete
  35. Hi there! Nice post! Please tell us when I will see a follow up! https://watchseries.world

    ReplyDelete
  36. I think this is an informative post and it is very beneficial and knowledgeable. Therefore, I would like to thank you for the endeavors that you have made in writing this article. All the content is absolutely well-researched. Thanks... https://gostream.network

    ReplyDelete
  37. Thanks for picking out the time to discuss this, I feel great about it and love studying more on this topic. It is extremely helpful for me. Thanks for such a valuable help again. https://1movies.media

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

    ReplyDelete
  39. When your website or blog goes live for the first time, it is exciting. That is until you realize no one but you and your. https://moviecrumbs.site

    ReplyDelete
  40. Really I enjoy your site with effective and useful information. It is included very nice post with a lot of our resources.thanks for share. i enjoy this post. https://hdtoday.website

    ReplyDelete
  41. Superior post, keep up with this exceptional work. It's nice to know that this topic is being also covered on this web site so cheers for taking the time to discuss this! Thanks again and again! https://fbox.today

    ReplyDelete
  42. Your blog is too much amazing. I have found with ease what I was looking. Moreover, the content quality is awesome. Thanks for the nudge! https://goojara.today

    ReplyDelete
  43. Awesome article, it was exceptionally helpful! I simply began in this and I'm becoming more acquainted with it better! Cheers, keep doing awesome! https://lookmovies.media

    ReplyDelete
  44. Awesome article, it was exceptionally helpful! I simply began in this and I'm becoming more acquainted with it better! Cheers, keep doing awesome! https://afdah.media

    ReplyDelete
  45. A great content material as well as great layout. Your website deserves all of the positive feedback it’s been getting. I will be back soon for further quality contents. https://playdesi.site

    ReplyDelete
  46. This is a great inspiring article.I am pretty much pleased with your good work.You put really very helpful information. Keep it up. Keep blogging. Looking to reading your next post. https://lookmovies.live

    ReplyDelete
  47. I appreciate this article for the well-researched content and excellent wording. I got so interested in this material that I couldn’t stop reading. Your blog is really impressive. https://soap2day.miami

    ReplyDelete
  48. Thanks for sharing the post.. parents are worlds best person in each lives of individual..they need or must succeed to sustain needs of the family. https://lookmovies.stream

    ReplyDelete
  49. I definitely enjoying every little bit of it. It is a great website and nice share. I want to thank you. Good job! You guys do a great blog, and have some great contents. Keep up the good work.
    https://watchserieshd.site

    ReplyDelete