SSIS newbie File System Task - Rename File -
10-30-2006
, 03:08 PM
This is my first SSIS package. I would like to rename the input file I
have loaded into a table,
to the orginal name prefixed by the date as yyyymmdd_. The underscore
character separates the date prefix from the original filename.
So far, it seems that that this transformation demands that the
destination file is specified [hard coded] into the package. I am
wondering if any of the property expresssions could be used to effect
this name change?
If not, which of the scripting methods would be most appropriate for
this simple task.
Thanks,
IanO |