- Posts: 189
- Thank you received: 9
Check File - Check File File Age variable always return Zero
- daniel.fung@xerox.com
- Topic Author
- Offline
- Elite Member
-
Less
More
6 years 11 months ago - 6 years 11 months ago #15814
by daniel.fung@xerox.com
i am using ETL 5.9.2.20 and looking at ways to get a Files created date etc. I know there is a script method as well as using the filesytem reader in a transmformation,
BUT i need a straight forward way to get the information from a file. so i saw and tried to use the Check File Action but see that it always return zero
better yet would be a filemetadata package level component like filecheck named say FileInfo where i could get
1. File Created Date ( full yyyymmdd hhmmss.tt or even the fileOS value like file age, though we will have to format it everytime)
2. File Last Modified Date
3. Size
4. Last Accessed Date etc
basically all the fields like the FileSystem reader minus the content
BUT i need a straight forward way to get the information from a file. so i saw and tried to use the Check File Action but see that it always return zero
better yet would be a filemetadata package level component like filecheck named say FileInfo where i could get
1. File Created Date ( full yyyymmdd hhmmss.tt or even the fileOS value like file age, though we will have to format it everytime)
2. File Last Modified Date
3. Size
4. Last Accessed Date etc
basically all the fields like the FileSystem reader minus the content
Last edit: 6 years 11 months ago by daniel.fung@xerox.com.
Please Log in or Create an account to join the conversation.
6 years 11 months ago #15815
by admin
Mike
ETL Architect
Replied by admin on topic Check File - Check File File Age variable always return Zero
Thank you for your feedback.
We will have a look at this one for you.
We will have a look at this one for you.
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
6 years 11 months ago #15816
by admin
Mike
ETL Architect
Replied by admin on topic Check File - Check File File Age variable always return Zero
Can you try latest version please
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
- daniel.fung@xerox.com
- Topic Author
- Offline
- Elite Member
-
Less
More
- Posts: 189
- Thank you received: 9
6 years 11 months ago #15817
by daniel.fung@xerox.com
Replied by daniel.fung@xerox.com on topic Check File - Check File File Age variable always return Zero
Just tested it, seems to be working great.
thanks.
thanks.
Please Log in or Create an account to join the conversation.