Post reply

Dynamic Source for flat File Source task in SSIS

  • December 24, 2008 at 4:21 am

    #204468

    Hi,

    I need to convert a flat file to DB using MS SSIS. I need a way to look into a particular folder to fetch the (only) flat file, filename is of the format "FileName-CCYYMMDD.txt".

    Please help me if there is way to add a file from the folder OR Get a file name of the format "Filename-CCYYMMDD.txt" where is CCYYMMDD is the current date or maybe CurrentDate -1 according to requirements.

    Any code examples or screenshots will be highly appreciated!

  • December 24, 2008 at 4:29 am

    #917304

    Please refer to the following website:

    http://www.mssqltips.com/tip.asp?tip=1084

    Hope this will help you further along

  • December 24, 2008 at 10:18 pm

    #917608

    thanks so much dude

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

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