File System Reader

About

File System Reader loads content of entire file into memory so it can transformed as a whole

It can be used to

• to load files content into the database blob fields.
• to load file metadata information into the database.
• to transform file content (replace or delete string fro example)

Properties

Tip: To change Reader properties double click on it.

Table creation SQL script example for MS SQL Server

create table FilesList
(
[Directory] [varchar](255) NULL,
[File Name] [varchar](255) NULL,
[Size] int,
[Created Date] datetime,
[Read Only] [varchar](6) NULL,
[Hidden] [varchar](6) NULL,
[Archive] [varchar](6) NULL,
[File Data] blob,
[Modified Date] datetime,
[Accessed Date] datetime
)

Video Tutorial