FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
See also the existing examples of using the SqlServer Adapter Adapter, which may answer your question: CSV text file import , flat file export , Import IDENTITY (Auto Increment) fields , CSV export divided into several files
  • Page:
  • 1

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

Need to run ms sql script at the end of the import process 2 months 3 days ago #3530

  • Doron Farber
  • Doron Farber's Avatar 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.

Need to run ms sql script at the end of the import process 2 months 2 days ago #3531

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.
Attachments:

Please Log in or Create an account to join the conversation.

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.

Need to run ms sql script at the end of the import process 2 months 2 days ago #3532

  • Doron Farber
  • Doron Farber's Avatar 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.

Need to run ms sql script at the end of the import process 2 months 1 day ago #3533

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.
Attachments:

Please Log in or Create an account to join the conversation.

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.

Need to run ms sql script at the end of the import process 2 months 1 day ago #3534

  • Doron Farber
  • Doron Farber's Avatar 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.

Need to run ms sql script at the end of the import process 1 month 4 weeks ago #3535

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.

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.
  • Page:
  • 1

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2019 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en