Post reply

UPLOAD MULTIPLE FILES

  • October 13, 2010 at 7:01 am

    #147281

    Hi,

    I have a requirment were have to upload multiple txt file to SQL SERVER 2005 using SSIS, can any one guide me through the process to use.

    Thanks

    Puneet

  • October 13, 2010 at 8:15 am

    #1236239

    What is your SSIS knowledge level? (We need to establish a starting point.)


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 13, 2010 at 8:16 am

    #1236242

    if the files are the same structure you can either loop through them using the for-each loop , or you can use the multifile connector.

    here is a good summary

    http://consultingblogs.emc.com/jamiethomson/archive/2006/10/14/SSIS_3A00_-Processing-data-from-multiple-files-all-at-once.aspx"> http://consultingblogs.emc.com/jamiethomson/archive/2006/10/14/SSIS_3A00_-Processing-data-from-multiple-files-all-at-once.aspx

    there are step-by-step guides to each on google/ BOL so i wont repeat them here

  • October 13, 2010 at 8:27 am

    #1236250

    Alvin,

    I am bit aware of SSIS, and think that i have sound knowledge.

    I am able to loop around all files(Source) using for each loop container but facing issue to create multiple tables for each file.

    Right now what i am able to do is importing all files one by one in one table in SQL, but i want it in multiple tables.

    thanks

    Puneet

  • October 13, 2010 at 8:43 am

    #1236271

    pujain (10/13/2010)

    Alvin,

    I am bit aware of SSIS, and think that i have sound knowledge.

    I am able to loop around all files(Source) using for each loop container but facing issue to create multiple tables for each file.

    Right now what i am able to do is importing all files one by one in one table in SQL, but i want it in multiple tables.

    thanks

    Puneet

    Can you give us some more information about what you're trying to do with mutiple tables and what problems your running into?

    Edit: Fingers and brain were operating at different speeds.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • October 13, 2010 at 9:13 am

    #1236297

    ok so here's the complete Scenario,

    Client provide us 11 different link for 11 different files (different contries) having ID's (numeric) in it. we match these id's with our Panel of members corresponding to each country and update a perticular column in the table.

    I was doing it manually until now but its a hectic process, so what i think is to upload 11 different files with there country name(helps in match back with our panel member). match the ID's + country name from the file with our panel and then update the required column.

    let me know if this explain all.

    thanks

    Puneet

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

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