SSIS Data import from XML file to SQL DB, giving error with type conversions RRS feed

  • Question

  • I use Visual Studio's, integration project to load XML file into SQL Server. In the XML file, i have defined collumns as string. When i try to load XML file with parts defined in scheme as string, i get an error "cannot convert between unicode and non-unicode string data type.

    I have tried to include data conversion step and still giving me error.
    Need help ASAP.
    Monday, March 8, 2010 10:53 PM


  • Hi,

    How do you use Data Conversion Task?  Please try to use Data Conversion Task to convert the field type into "[DT_STR]".

    For more information about "Importing Excel data with SQL Server Integration Services SSIS with unicode and non-unicode data", please refer to


    Please feel free to let me know if I’ve misunderstood anything.
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.
    Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
    • Marked as answer by Zongqing Li Monday, March 15, 2010 8:27 AM
    Thursday, March 11, 2010 6:30 AM