January 31, 2013 at 12:40 pm
HI,
I am trying to write a ssis package which moves clients file from certain directory to another.
Source Path : D:\Temp\Source\Client A_CSV
D:\Temp\Source\Client B_CSV etc
Source Directory has many folders of clients like Client A_CSV etc.
I want that when i move files to ARCHIVE directory,so that it rename the files with time stamp.
So far, i have been able to move with file task, but it does not allow me to rename file as I retrieve
FULLY QUALIFIED PATH as loop enumerates,
So,,any idea ,, how i accomplish renaming with file system task or Script Task,
Thanks
January 31, 2013 at 6:47 pm
Go through the following articles. Let us know if this still doesn't solve your question.
http://www.rafael-salas.com/2007/03/ssis-file-system-task-move-and-rename.html
Sam Vanga
http://SamuelVanga.com
February 1, 2013 at 3:51 am
a bundle of Thanks
February 1, 2013 at 7:03 am
It is a lot of work to do this in SSIS. Do you have to use SSIS? You could do this with a single line of PowerShell too.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 14, 2013 at 4:56 am
i have a new problem .
i am writing ssis package having For Each Loop Container Which iterates through DropBox Folder ..
But when it iterates, it gives error : Desktop.ini File in DropBox is not Recognized.
How do i ignore this .ini file while iterating through Dropbox ?
February 14, 2013 at 5:15 am
iamsql1 (2/14/2013)
i have a new problem .i am writing ssis package having For Each Loop Container Which iterates through DropBox Folder ..
But when it iterates, it gives error : Desktop.ini File in DropBox is not Recognized.
How do i ignore this .ini file while iterating through Dropbox ?
Please do not cross-post. Answers here please.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply