Post reply

xml task doesn't insert any records

  • September 3, 2008 at 9:53 am

    #154689

    Please help,

    I'm having a hugh xml file(around 2gb) and an xsd. I'm using xml task to do xml/xsd transformation(All good, I can see all the tables, 200 of them), But when I execute the Pacakage it doesn't insert any records in that tables, and to my surprise i get DTSER_SUCCESS Message. Is there anything that i'm doing wrong.

  • September 3, 2008 at 9:56 am

    #866595

    Is it possible to view the code you are using?

  • September 3, 2008 at 10:04 am

    #866603

    I'm not writing any code. below are the steps that i performed.

    1. Created xml Source with (xml and xsd)

    2. Created 200 datapumps(for 200 tables)

    3. Created an OLE DB Destination(SQL 2005 DB)

    4. Created 200 Transformation to pump the data in those tables.

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

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