Post reply

Data Reader SQL Command dummy necessary

  • May 18, 2009 at 6:21 am

    #137837

    Hello,

    I assigned a sql command to my data reader by using the expression of the data flow task.

    the sql command of the data reader still needs a value to validate.

    Is it sufficient to give it a dummy select since the expression (the real select) will overwrite

    the sql command of the data reader?

    thanks

  • May 18, 2009 at 8:06 am

    #996345

    I just executed my package but the validation time is taking ages....running since 9 minutes validating

    my data flow task.

  • May 18, 2009 at 9:15 am

    #996422

    Can you provide more information about what you're trying to accomplish? It looks like you're trying to script in SSIS but it's unclear what your goal is.

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

  • May 18, 2009 at 1:35 pm

    #996592

    Hi Tim,

    I cracked down on the validation. I am using a for loop in ssis to loop through years like 2000 +1, 2001+1, 2002+1 < 2003.

    Each year has about 50 000 records that will be inserted into my oracle db form an as400.

    I used this looping trick to overcome the oracle buffer overflowing before the "commit". I hope

    that will work i.e. the rows will be instered in batches. I am running the package now and keep the result posted here.

  • May 19, 2009 at 8:33 pm

    #997352

    Thanks for the update, let me know how it turns out.

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

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

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