Post reply

Load a excel file with a particular name using SSIS

  • October 12, 2011 at 11:39 am

    #260276

    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!

  • October 16, 2011 at 5:12 pm

    #1395112

    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