Post reply

How to Fetch a single files from the local path using SSIS package

  • November 14, 2014 at 12:11 am

    #301120

    Hi Friends,

    I have 15 Dealers files .With the Files name as follows

    1. ''ACTEST00001_20141112_0408_INV.TXT''

    2. ''ACTEST00002_20141112_0408_INV.TXT''

    I will get these files through FTP on Daily basis with changes on date alone.

    I will have 4 files for each dealers.like INV,SERVICE,SALES,APPOINTMENT.

    SO i need to fetch a particular dealer with particular date.

    I need to create this scenario in SSIS package.Please suggest me how to create this and what are all the Tasks i need to use to implement this process.

  • November 14, 2014 at 8:52 am

    #1758644

    Since you specify that you need to get files for a specific date and dealer, is there an identifying dealer name in the file? I am going to assume ACTEST is dealer name.

    I would create two variables, one for dealer name and one for date. Assign the variables as needed and then use an expresssion in the ftp task for either name or remote name with something like this:

    @[User::dealer] +"0000?_"+(dt_str,4,1252)DATEPART("yyyy", @[User::userdate])+(dt_str,4,1252)DATEPART( "mm", @[User::userdate] )+(dt_str,4,1252)DATEPART( "dd", @[User::userdate] )+"_0408_*.txt"

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

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

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