Cannot convert "Column" between a unicode and a non-unicode string data types in SSIS

-
Error:
Cannot convert "Column" between a unicode and a non-unicode string data types in SSIS

Solution 1:
1. Right click on source task.
2. click on "Show Advanced editor". -- advanced edit option for source task in ssis
3. Go to "Input and Output Properties" tab.
4. select the output column for which you are getting the error.
5. Its data type will be "String[DT_STR]".
6. Change that data type to "Unicode String[DT_WSTR]". --Changing the data type to unicode string
7. save and close.

Solution 2:
Add Data Conversion transformations to convert string columns from non-Unicode (DT_STR) to Unicode (DT_WSTR) strings.
You need to do this for all the string columns

Comments

  1. Veera BlogspotWed Dec 23, 01:32:00 pm

    Great article with very unique content.
    Thank you...

    MSBI Online Training Hyderabad

    ReplyDelete
  2. MSBIDevSat Oct 02, 12:24:00 pm

    Nice information

    ReplyDelete
  3. Balu ChallaSat Dec 11, 09:13:00 pm

    Thanks for your feedback

    ReplyDelete
  4. LavanyaWed Jan 26, 01:54:00 pm

    It 's an amazing and awesome blog. Thanks for sharing
    Msbi Training
    Msbi Online Course

    ReplyDelete
  5. LavanyaFri Jan 28, 01:42:00 pm

    Thanks for your information. very good article.

    Msbi Training
    Msbi Online Course

    ReplyDelete
  6. laxmicynixitThu Oct 20, 08:38:00 pm

    nice information ............!
    msbi course training

    ReplyDelete
  7. Franklin JonesMon Feb 27, 05:23:00 pm

    Very interesting, good job and thanks for sharing such a good blog. Your article is so convincing that I never stop myself to say something about it. You’re doing a great job. Keep it up and take a look at my article which will show you link to the google play store

    ReplyDelete
  8. Omar SettyMon Mar 13, 05:50:00 pm

    This is highly informatics, crisp and clear. I think that everything has been described in systematic manner so that reader could get maximum information and learn many things. Thank you so much. Just check here and you will get to know about Classification of color blindness if you have color vision deficiency.

    ReplyDelete
    Replies
    1. Balu ChallaThu Mar 16, 11:37:00 am

      Thanks for your valuable feedback and please subscribe my blog for more updates.

      Delete
  9. Achal ChaudharyMon Mar 20, 11:47:00 am

    Thanks for sharing your thoughts. I truly appreciate your efforts and I will be waiting for your further post thank you once again. Nice article I am also share with everyone my work experience to in my blog so visit Best Gay Quiz Online

    ReplyDelete
    Replies
    1. Balu ChallaMon Mar 20, 12:11:00 pm

      Thanks for your valuable feedback and please subscribe my blog for more updates.

      Delete
  10. Kim LancerTue Apr 25, 11:48:00 am

    Thanks for any other wonderful article. Where else may anyone get that kind of info in such an ideal way of writing? Alѕo νisіt my web blοg DownloadRobloxPlayer.Exe

    ReplyDelete
    Replies
    1. Balu ChallaTue Apr 25, 12:03:00 pm

      Thanks for your valuable feedback and please subscribe my blog for more updates.

      Delete
  11. mahima BannergieFri May 05, 02:35:00 pm

    The post is written in very a good manner and it entails much useful information for me. I am happy to find your distinguished way of writing the post. Now you make it easy for me to understand and implement the concept.I have one more information related with roblox..DownloadRobloxPlayer.Exe

    ReplyDelete
    Replies
    1. Balu ChallaFri May 05, 03:47:00 pm

      Thanks for your valuable feedback and please subscribe my blog for more updates.

      Delete
  12. Marry HasslerWed May 10, 01:29:00 pm

    I was waiting for this visit from the very beginning of the Blog Hop and I'm happy that I discovered your blog, because you are making beautiful post! Look at this very wonderful website am i gay test

    ReplyDelete
    Replies
    1. Balu ChallaThu May 11, 11:01:00 am

      Thanks for your valuable feedback and please subscribe my blog for more updates.

      Delete
  13. Kim LancerFri May 26, 10:26:00 am

    I got a web site from where I be capable of really obtain valuable information regarding my study and knowledge. Great Article… Good Job… Thanks For Sharing… also, you can check Color Blind Test

    ReplyDelete
    Replies
    1. Balu ChallaTue May 30, 09:57:00 am

      Thanks for your valuable feedback and please subscribe my blog for more updates.

      Delete
  14. Julia BeardMon Jun 26, 03:47:00 pm

    Great and very accommodating for all the people out there learning the concept of Machine Learning and algorithms used in Machine Learning and I should also recommend them because it has helped me a lot and I am sure that it will do the same for you! also sharing some information about online gay test.

    ReplyDelete
    Replies
    1. Balu ChallaMon Jun 26, 04:24:00 pm

      Thanks for your valuable feedback and please subscribe my blog for more updates.

      Delete
  15. Peter DanTue Jun 27, 01:00:00 pm

    Thank you very much for your great information. It really makes me happy and I am satisfied with the arrangement of your post. You are really a talented person I have ever seen. If you have time, please visit here accurate gay test

    ReplyDelete
    Replies
    1. Balu ChallaTue Jun 27, 01:52:00 pm

      Thanks Peter for your valuable feedback and please subscribe my blog for more updates.

      Delete
  16. Rafel JacksonThu Jun 29, 04:13:00 pm

    Hey Thanks for sharing this blog its very helpful to implement in our work. I am sharing related topic which is most important on heterosexuality of men

    ReplyDelete
    Replies
    1. Balu ChallaFri Jun 30, 07:11:00 pm

      Thanks for your valuable feedback and please subscribe my blog for more updates.

      Delete
  17. Tia DsouzaWed Jul 05, 02:59:00 pm

    The postings on your site are always excellent. i really loved the content in it Thanks for the share and keep up this great work! All the best to you. please keep updating on purple eyes

    ReplyDelete
    Replies
    1. Balu ChallaWed Jul 05, 03:52:00 pm

      Thanks for your valuable feedback and please subscribe my blog for more updates.

      Delete
  18. Alora MorganWed Jul 05, 02:59:00 pm

    thank you for the information! I was looking for and could not find. You helped me! I found so many interesting things related to it but not found the legit information. Look at this very wonderful website purple eyes myths and facts

    ReplyDelete
    Replies
    1. Balu ChallaWed Jul 05, 03:52:00 pm

      Thanks for your valuable feedback and please subscribe my blog for more updates.

      Delete
  19. Marry HasslerThu Jul 13, 03:47:00 pm

    I got a web site from where I be capable of really obtain valuable information regarding my study and knowledge. Great Article… Good Job… Thanks For Sharing… also, you can check virtual credit cards

    ReplyDelete
    Replies
    1. Balu ChallaThu Jul 13, 06:52:00 pm

      Thanks for your valuable feedback and please subscribe my blog for more updates.

      Delete
  20. Tia DsouzaThu Aug 10, 05:17:00 pm

    Thanks For Sharing Such beautiful information about the Blog. Your way of writing and clarifying things is very impressive I truly appreciate your writing style this is very useful.. For academic writing work, you can check my work improve reaction time

    ReplyDelete
    Replies
    1. Balu ChallaWed Aug 16, 09:15:00 am

      Thanks for your valuable feedback and please subscribe my blog for more updates.

      Delete
  21. Heri ThomasMon Sept 04, 03:26:00 pm

    Thank you because you have been willing to share information with us. This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free.Taκе a look at mу ωeb site Reaction Time Test

    ReplyDelete
    Replies
    1. Balu ChallaWed Sept 06, 04:09:00 pm

      Thanks for your valuable feedback and please subscribe my blog for more updates.

      Delete

Post a Comment

Hi User,
Thanks for visiting My Blog and please provide your valuable feedback and subscribe for more updates. Please don't post any spam content or comments.
Thank You

Popular Posts

Failed to execute the package or element. Build errors were encountered

-
Error: TITLE: Microsoft Visual Studio ------------------------------ Failed to execute the package or element.   Build errors were encountered. For more information, see the Output window. ------------------------------ BUTTONS: OK ------------------------------   Solution: We tried to close SSDT and run it again but, we still got the same error while running SSIS package. Then, we need to follow bellow solution: Step 1: Go to Task Manager–> Details Tab. Step 2: Locate the process “ DtsDebugHost.exe “. Kill this process. There might be multiple instances of this process. Kill all of them. Step 3: Rerun SSIS package
Read more

Exception deserializing the package "The process cannot access the file because it is being used by another process."

-
TITLE: Microsoft Visual Studio ------------------------------ Failed to start project ------------------------------ ADDITIONAL INFORMATION: Exception deserializing the package "The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process.". (Microsoft.DataTransformationServices.VsIntegration) ------------------------------ The process cannot access the file 'E:\SSASCube\HistoricalDataLoad\HistoricalDataLoad\bin\Development\HistoricalDataLoad.ispac' because it is being used by another process. (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ While running SSIS package i got the error “The process cannot access the file ‘*.ispac’ because it is being used by another process”. I tried to close SSDT and run it again but, I still got the same error while compiling. Then, after searching over internet, I got
Read more

Temporary enable and disable SSRS subscriptions

-
--Code Snippet --To Check Subscription Status. USE ReportServer GO SELECT dbo . Subscriptions . Description ,        dbo . [Catalog] . Name ,        dbo . Users . UserName ,        InactiveFlags FROM dbo . Subscriptions      INNER JOIN dbo . [Catalog]      ON dbo . Subscriptions . Report_OID = dbo . [Catalog] . ItemID      INNER JOIN dbo . Users      ON dbo . Subscriptions . OwnerID = dbo . Users . UserID --Temporary disables subscriptions while data warehouse is unavailable UPDATE dbo . Subscriptions SET InactiveFlags = 1 GO --After this you can find, all the subscription where disabled until you again enable it. --Again enable subscriptions. UPDATE dbo . Subscriptions SET InactiveFlags = 0 GO
Read more