Post reply

import XML into SS08 table

  • December 30, 2009 at 8:22 am

    #215354

    <?xml version="1.0" encoding="utf-8" ?>

    - <MSNOnlSvcInfo xmlns:msxml="urn:schemas-microsoft-com:xslt" Version="2.0">

    - <ProviderSettings>

    <XXID>201</XXID>

    <Name>WoodGrove Direct 1.02</Name>

    <Address1>One Microsoft Way</Address1>

    <Address2>RedWest B</Address2>

    <Address3 />

    <City>Redmond</City>

    <State>WA</State>

    <Zip>98052</Zip>

    this is part of the xml i am tring to upload. i have attached a scrn shot of the error for conversion.

    trying to import buch of xml into ss08 table.

    thanks

    Noli Timere

  • December 30, 2009 at 8:39 am

    #1097488

    The error you're getting says you have data conversion issues. Take a look a the columns referenced in the error message and see what data type they are. It's not compatible with the data type of the destination or of some conversion in between.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 2 posts - 1 through 1 (of 1 total)

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