June 1, 2012 at 2:41 am
Howdy,
well apparently i need to build a catalog via expression. To move FTPd document there each day, archiving.
The end result needs to be:
c:\ftp\archive\01-JUN-2012
And for tomorrow:
c:\ftp\archive\02-JUN-2012
How do i do that ?
the first part, "c:\ftp\archive\" is probably wise to put into it own variable, then i think i can call it up with @[variable:name]+datenamedcatalog
So how can i create this "datenamedcatalog" thing ?
June 1, 2012 at 7:03 am
For other's who struggle:
@[User::catalog]+
RIGHT("0" + (DT_STR,4,1252) DatePart("yyyy",getdate()),4) +
@[User::slash]+
Right("0" + (DT_STR,4,1252) DatePart("d",getdate()),2)+
"-"+
Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2)
Few my own variables there but it's more or less understandable (definitely less :)) Why oh why needs a simple thing be so complicated in code wise:hehe:
June 1, 2012 at 8:12 am
Marttali has put you more or less on the right track. However I would suggest a different naming convention for your archive file: yyyymmdd. This way it is easy to sort your files by name chronologically. Also, don't forget your .txt or other file extension in your expression.
June 1, 2012 at 8:53 am
Oh, it's just a catalog(s) where stuff get's moved. Not file name. File name comes from database via select..
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply