ETL and Data Integration tools - Modern ETL software for everyone

Hello!

I'm creating a package.

Once the transformation is done, I want to move the CSV files to another folder and then rename them.
I have successfully moved the files using and my problem is renaming it.
How can I do this?
I tried using the Zip File action. It turned out ok. I zipped the files and moved it into a new directory.

How to rename an existing file using transformation?
I just want to change its extension form .csv to .processed

Pol

Yes it is possible, using script action

1. create new package
2 add script and use this script

var i: integer;
Rec : TSearchRec;
Attr : integer;
SearchDirectory,TargetDirectory,Mask : string;
begin
SearchDirectory:='c:\';
Mask:='*.csv';
TargetDirectory:='c:\temp\';
Attr := faReadOnly+faHidden+faArchive+faAnyFile;
if FindFirst(SearchDirectory+Mask,Attr,Rec) = 0 then
try
repeat
if ((Rec.Name='..') or (Rec.Name='.'))=false then
begin
RenameFile(SearchDirectory+Rec.Name,TargetDirectory+ChangeFileExt(Rec.Name,'processed'));
end;
until FindNext(Rec) <> 0;
finally
FindClose(Rec);
end;
result:=true;
end;


Mike

Thank you for quick reply

It works now

Pol