ETL Script to Insert BLOB from File into a Database

/ Published in: XML
Save to your folder(s)

Scriptella ETL allows inserting files into a database. This is achieved by a simple bind variables extension syntax ?{file ...}.
The following sample initializes table of music tracks. Each track has a DATA field containing a file loaded from an external location. File song1.mp3 is stored in the same directory as etl.xml and song2.mp3 is loaded from the web:


Report this snippet


RSS Icon Subscribe to comments

You need to login to post a comment.