Post reply

a bunch of data flow tasks, how are they generated?

  • March 30, 2012 at 12:08 pm

    #149871

    We have a ssis package that has about 80 data flows tasks in it. It was created by a contractor who has left us.

    They are all data flows that import data from flat files from one directory to a same database .

    From what I see in BIDs, it doesn't look like each task is created individually, they all look the same format, I think they are generated somehow by batch, but I don't know how?

    Any ideas?

    Thanks

  • March 30, 2012 at 12:23 pm

    #1467128

    Probably not a batch process...more likely copy/paste. You can copy Data Flow tasks, and then paste them back to the same Control Flow surface to gain a complete copy. If they are all very similar, that was likely the approach to get to count up to 80.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • March 30, 2012 at 12:38 pm

    #1467141

    Thanks a lot

  • April 1, 2012 at 11:42 pm

    #1467487

    Or the import/export wizard was used.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • April 2, 2012 at 12:29 am

    #1467492

    Koen Verbeeck (4/1/2012)

    Or the import/export wizard was used.

    I did not know you could use the I/E Wizard to create more than one Data Flow task in a single package.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • April 2, 2012 at 12:31 am

    #1467494

    Well, the wizard will create multiple dataflows if you import a lot of sources.

    I believe the wizard puts around 5 sources in one dataflow, and then creates a new one.

    I once imported 60 tables from Oracle, so that gave me about 12 dataflows, all of them looked very similar of course.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • April 2, 2012 at 12:34 am

    #1467495

    OK, tables, yes, I was aware that you could select more than one table in the wizard but the OP was asking about flat files.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • April 2, 2012 at 12:39 am

    #1467496

    opc.three (4/2/2012)

    OK, tables, yes, I was aware that you could select more than one table in the wizard but the OP was asking about flat files.

    You're right.

    This makes copy/paste a more likely scenario 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 8 posts - 1 through 8 (of 8 total)

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