Using loop connection variable in import wizard

[jafnaharris]

Is there an option to use loop variable in import wizard? I extracted data looping through a variable (from driver query) and instead of loading it to a file, I tried to use import wizard to import that data to database table. I would like to know if this worked for anybody or is there a better way to do this.

[mercier104_000]

Hi,
what do you want to loop on ?

I use to do that with "find and replace" activity.

first, creating loop dataset variable

find and replace of "keywords" from a template sql file to a temp sql file

then "execute script" or "import template" from this temp sql file.

Hope this help...