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).

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • 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 3 (of 3 total)

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