-
Doron Farber
-
Topic Author
-
Offline
-
Posts: 4
-
-
|
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: UPDATE Prices
SET [Price] = SUBSTRING(Price,2,10),
[PriceFlag] = 'GBP'
Where is the spot to stick this code?
Thanks,
Doron
|
Please Log in or Create an account to join the conversation.
Last edit: by Doron Farber.
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
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.
UPDATE Prices
SET [Price] = SUBSTRING(Price,2,10),
[PriceFlag] = 'GBP' WHERE CUSTOMER = ‘$CUSTOMER_ID$’
Note: In this case you have to set the
FlowHeater Parameter
$CUSTOMER_ID$ with the
Set Parameter Heater
before using.
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
|
Please Log in or Create an account to join the conversation.
|
-
Doron Farber
-
Topic Author
-
Offline
-
Posts: 4
-
-
|
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
|
Please Log in or Create an account to join the conversation.
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
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.
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
|
Please Log in or Create an account to join the conversation.
|
-
Doron Farber
-
Topic Author
-
Offline
-
Posts: 4
-
-
|
Thanks for the reply.
Do you have links with sample to all features including upload files from FTP into the database?
Regards,
Doron
|
Please Log in or Create an account to join the conversation.
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
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.
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
|
Please Log in or Create an account to join the conversation.
|
Time to create page: 0.238 seconds