Post reply

sql 2005 ssis load xlsx files

  • March 9, 2009 at 11:06 am

    #95107

    Hello there,

    this is my first post, so thank a lot in advanced for your help.

    Now the problem:

    I have a ssis that import a xlsx file (excel 2007 file) to a table and it works fine. But now for complicate the situation i need to import other xlsx files (with same structure of the first file) but i want to choose what file to import when i need.

    Ex:

    i have a directory with 3 xlsx files: Book1.xlsx, Book2.xlsx and Book3.xlsx;

    today i need to import the book2.xlsx but tomorrow i need to import te book1.xlsx.

    So i need help on this because i already saw same samples but or import just one file ou import all the files in directory.

    I need to import an especific file at a especific time. just that. 🙂

    can anyone help me on this?

    thanks a lot for your time.

    Best Regard.

  • March 11, 2009 at 9:51 pm

    #958060

    It's not clear in your post what would be the deciding factor for which of the Excel files to use. If you're going to manually run the file every day, you can simply copy the file(s) of the day to a designated directory and use a ForEach loop to read and process each one. Since the files are structured identically, you'll reuse the same package for all.

    hth,

    Tim

    Tim Mitchell
    TimMitchell.net | @tmitch.net | Tyleris.com
    ETL Best Practices

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

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