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

8 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 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