Data Source is a File System
File System source can be used
- to load files content into the database blob fields.
- to load metadata information into the database.
It recommended exporting data once it loaded into the database for additional testing.
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
)
For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions
Confused? Ask question on our ETL Forum