• parthi-1705 (11/17/2010)


    Hi, I just copy and past but getting error

    It looks like there are a couple of errors. First of all, the elseif should be else if. It looks like the browser causes those to run together for some reason.

    The highlighted error indicates that you don't have a variable named Filename in this scope. You'll want to create a variable with this name in your package, which should be populated with the name of the file you want to shred.

    hth,

    Tim

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