Post reply

insert data in more than one tables from XML file

  • October 14, 2010 at 1:52 am

    #230344

    Hi Folks,

    I have assigned a task to insert the data from XML file to the respective tables.Befrore that, these XML files will b available from Client's FTP Server. So i need to download these XMLs(in every 10 minutes) from FTP to over local server.Now one by one from these each XMLs data will be inserted to 11 respective table. Can any one suggest me how to go through this task to achieve my goal.

    Actually, I am new to SSIS so unable to handle the situation....:w00t:

    I have attached the XML sample & Some of the tables

    Please help!!!!!!!!!!

  • October 14, 2010 at 2:34 am

    This was removed by the editor as SPAM

  • November 14, 2010 at 10:39 am

    #1250449

    Hi Stewartc,

    Thanks for ur kindly support!

    Actually, I'm facing a problem when downloading XML files from FTP server. Everytime its giving me only 1 file.I wana use For eachloop but it's stuck as I don't know how to implement.Can you provide me the steps with screen shote that need to be done to wrap FTP task with FOR EACH LOOP container. It'll be very helpful for me.

    Thanks

    Anurag

  • November 17, 2010 at 12:10 am

    #1251701

    Hi All,

    Please help me out from the above issue or provide an alternate to download multiple files form FTP server.

    Thanks

    Anurag

  • November 19, 2010 at 7:29 am

    This was removed by the editor as SPAM

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

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