how do you create and load your import set table?

if pro grammatically, then you should set have importsettable.sys_import_set =  your importset sysid there, plus you will need to populate row column.

after your could do your transform, transform code shall include your importset with state "loaded"