Post reply

SSIS2k8 XML file to SS

  • April 19, 2010 at 8:13 am

    #140392

    Hi,

    I have a package that picks up an xml file and saves the data to SS2008. One of the columns is a text fields and is defined as:

    <xs:element minOccurs="0" name="incidentDetail" type="xs:string" />

    there is a data conversion and the datatype is Unicode string {DT_WSTR] length = 4000

    The database column is NVarChar(4000)

    The data gets inserted but is truncated.

    There are 391 characters in one particular fiels and it truncates the text after 249 characters.

    Here is my question(s) What is a good debugging method to determine why this is happening, and what would cause the text to truncate at such an arbitary length?

    Thanks.

    John

    John A. Byrnes

  • April 19, 2010 at 10:12 am

    #1153957

    I'm willing to bet that the output field from the source is configured for 255 characters. Use the Advanced Editor to see how that field is defined. You should be able to adjust it there.

    CEWII

  • April 19, 2010 at 10:24 am

    #1153969

    Yep. You got it. Istrated to look at the same thing, and thought that 249 characters is pretty close to 255 which is what I'm seeing in the Data Coversion Input is length 255.

    Thanks for the help.

    PS I was also going to ask about why my bulk inert wasn't firing a trigger, but after staring at the BulkInsertFiretrigger = False the light came on. Slowly.

    John

    John A. Byrnes

  • April 19, 2010 at 10:29 am

    #1153972

    You are very welcome.

    CEWII

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply