Hi

I am creating a flat file (destination) in ssis with the naming convention (bh5601_yyyymmddhhmmss.bdf). Each day a file is created with different name.

I am using the following expression in the flatfile connection manager proerty box to give dynamic name to the file.

"C:\\Users\\Downloads\\bh5601_"+(DT_STR,4,1252)DAT EPART( "yyyy" , @[System:tartTime] ) +
RIGHT("0" + (DT_STR,4,1252)DATEPART( "mm" , @[System:tartTime] ), 2) +
RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , @[System:tartTime] ), 2) +
RIGHT("0" + (DT_STR,4,1252)DATEPART( "hh" , @[System:tartTime] ), 2) +
RIGHT("0" + (DT_STR,4,1252)DATEPART( "mi" , @[System:tartTime] ), 2) +
RIGHT("0" + (DT_STR,4,1252)DATEPART( "ss" , @[System:tartTime] ), 2)+".bdf"

It is working well. Now after the file is ctrated, i am using the FTP task to pick up that particular file and sent to remote path. I am able to configure the remote path but can any body telll me how to make local path dynamic.

Flat file is created everyday. so i want ftp task to pick up file with correct datetime stamp.

Please help.

Thanks

There program call ftpdeamon that watcher a folder and then FTP the files in that folder to the FTP place then all you have to is write some scrip to copy said file to that folder and it done.