dbTalk Databases Forums  

SSIS newbie File System Task - Rename File

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SSIS newbie File System Task - Rename File in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
IanO
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.