Data Source is a File System

File System source can be used

  1. to load files content into the database blob fields.
  2. 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

  • vimp/data_sources/filesystem.txt
  • Last modified: 17/09/2018 11:42
  • by admin