Create Multiple XML Files using SSIS

  • Hi community,

    I have a table in my database which consists of 100,000 rows.

    I am trying to move this data to 10 XML files (10,000 each rows).

    I am able to convert my data to XML format using ZS Export XML Task.

    I basically want my XML files like this: Individual_1.xml, Individual_2.xml, Individual_3.xml and so on....

    What would be the best and fastest way to achieve this?

    Thanks.

     

  • This question is strikingly similar to this one.

    Perhaps the responses you received there were not to your liking? You did not even have the courtesy to respond to the final suggestion (other than complaining about its length).

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • Phil Parkin wrote:

    This question is strikingly similar to this one.

    Perhaps the responses you received there were not to your liking? You did not even have the courtesy to respond to the final suggestion (other than complaining about its length).

     

    I apologize. I am actually currently working on that and following that post. I was stuck at something different and couldnt form the new post correctly. I will update it.

    Really sorry.

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

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