Need to run ms sql script at the end of the import process

Hello,

Need to run ms sql script at the end of the import process. All records where imported from a spread sheet into ms sql table and in this point I need to run this code:
Where is the spot to stick this code?

Thanks,

Doron

Hi Doron,

You just have to use the SQL Heater and switch the “Execute when” option to “Finish” like the screenshot below.
In case you need a dynamic SQL statement with values from some fields, you can use FlowHeater Parameter as placeholder as well like this.

Note: In this case you have to set the FlowHeater Parameter $CUSTOMER_ID$ with the Set Parameter Heater before using.

Hi Robert,

So I can choose any heater of the fields? Then there are several options to choose from the heater.
Insert Clone Heater
Switch to a New Layer
Configure Layer

Did not see this option as: Execute when

This is an Excel Adapter to SqlServerAdapter.

Thanks,

Doron

Hi Doron,

Of course, you have to use the SQL Heater instead of the Clone Heater . Only the SQL Heater and a few more functions supports to run at Start or at the End (=Excecute when “Finish”) during the import/export process.

Thanks for the reply.
Do you have links with sample to all features including upload files from FTP into the database?

Regards,

Doron

Hi Doron,

To synchronize FTP files or folders you can use the CMD Heater and call for example WinSCP or filezilla with command line options during the import process.

Afterwards it would be possible to import certain files (content) with the File Heater to a SQL Server database table. If you need more assistance, please open a new support thread and add a few more details what you want to do, Thanks.