Incremental Load based on file name containing a date

[alec1982]

hi,

Anyone has a quick script to do incremental load based on file names where the file names have dates in it.

Example of files names:

2015-10-01-MainSales..xlsx

2015-10-02-MainSales..xlsx

2015-10-03-MainSales..xlsx

Thxs,

Alec

[marcus_sommer · Accepted solution]

Your dates from the filename could you extract with filebasename, maybe like:

date(date#(left(filebasename(), 10), 'YYYY-MM-DD'), 'YYYY-MM-DD')

and various examples and explanations to incemental loads will you find here:

Incremental Load

Incremental Load Scenarios

CRUDhelper framework - Incremental loads with ease

- Marcus

[alec1982]

thank you Marcus..