Post reply

generate multiple excels

  • March 24, 2015 at 7:32 am

    #295283

    Hello everyone,

    I'm new in SSIS a i have problem with generate multiple excels,

    i have 400 locations and 3 product and a want generate excel for every location for every product

    it should give me 1200 excels,

    maybe i should create package and create batch file and run this package from batchfile

    but i don't know how

    maybe somebody give me some advice or maybe someone has a similar problem

    Best regards

    Lucas

  • March 25, 2015 at 3:42 am

    #1786211

    Where are the location and product stored?

    If it is stored in a table, then you can easily create 400 excel files from a single SSIS package. No need to execute it from a batch file.

    ____________________________________________________________

    AP

  • March 25, 2015 at 3:48 am

    #1786212

    location and product are in the same table which i want to extract data

    location is in first columns, product is in second

  • March 26, 2015 at 12:26 am

    #1786463

    Easy way, Extract data in Execute SQL Task. Then use a For each loop container and place a DFT inside it.

    Iterate thru extracted data and create Excel file for each set in DFT.

    ____________________________________________________________

    AP

  • March 26, 2015 at 3:59 am

    #1786492

    thanx, i'll try

    i'm doing it first time so it's take me a few hours, but if I can't done this i will write post on this site 🙂

    best regards

    Lucas

  • March 27, 2015 at 6:25 am

    #1786836

    It came out like I thought, i'm trying to find simlar things in google but when i find something it didn't work corectly

    i have request, could You send me a .dtsx file with Your sample data, because I want to see how it should looks like

    Maybe i'm doing something wrong because it didn't work

    Best regards

    Lucas

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

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