Post reply

how to get filename dynamically by passing variable in file system task

  • July 7, 2011 at 5:49 am

    #241126

    hi,

    I need to get file name dynamically if i pass a variable. My file name consists of name with current date it has to take only current file and copy into same folder. if i am writing expression it throws an error.

    @[User::new_a]+(DT_STR, 8, 1252)(YEAR(GETDATE()) * 10000 + MONTH(GETDATE()) * 100 + DAY(GETDATE()))+".txt"

    E:\DATA\TEST.NEW1.20110707.txt

    it is nor reading data from that source showing error

    can any one help.................

  • July 7, 2011 at 6:07 am

    #1349606

    What is the actual file name? Something like E:\DATA\TEST\NEW1_20110707.txt? What is the value of new_a? You either need to make sure that the variable contains the correct file name pattern, or do some manipulation on it to get the correct pattern. What error message are you getting?

    John

  • July 7, 2011 at 6:21 am

    #1349623

    hi ,

    plz find the atttachment.

  • July 7, 2011 at 6:27 am

    #1349630

    This is because you're trying to access a variable called "E:\BINDU\TEST.NEW1.20110707.txt". Surely that is the value of the variable, not its name? I need to see how you're referring to that variable - is it possible for you to post your package file?

    John

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

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