Load a excel file with a particular name using SSIS

  • Hello All,

    I get a file with a particular name with that day's time stamp (Customer_Ticket-10-Oct-2011.xls) into a shared folder everyday. There are a number of other files that are already present in that shared folder.I need to load only that file into my table.

    I saw a blog where there were using a script task to generate the file name. I am pretty sure there might be a simpler way than that.

    Can anybody suggest a way to load this file ?

    Thanks in advance!

  • Simply, you're going to have to set the filename with an expression. There are other ways but none are 'better' without becoming relatively complex, and all are logic dependent afaik.

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

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