Sep 7, 2017 · I'd like some component equivament to Execute SQL Script to read a .sql file, take its content and send it to MSSQL. It would be awesome if I could provide the connection string on the sql file, or at least set it as a ktr parameter.

I want to insert data from a csv file to a custom DB, which does not support the "insert table" step. So i would like to use the sql script step, with one request : INSERT INTO myTable SELECT * FROM myInput

Nov 18, 2014 · I have a Pentaho - Kettle transformation which loads data from two separate csv files, then applies a 'unique rows(hashset)' transformation. Can I execute a SQL script based on the output of the 'unique rows' step? I'd like to run something like. select field1, sum(field2) as MyCalc from InputTable group by field1 having sum(field2) > 100

Aug 13, 2021 · You can execute SQL scripts with this step, either once, during the initialization phase of the transformation, or once for every input-row that the step is given. The second option can be used to use parameters in SQL scripts.

Sep 6, 2023 · To start spoon run the bat file: D:\pdi\spoon.bat. Linux and Mac users should find and run the equivalent shell script to launch Spoon. Our First Transformation. In this tutorial we are...

My question is simple: how can I run an SQL script on a table inside Kettle, in the stream. For example, let's assume the following: I generated a table (data grid) and then, I want to run an SQL select on it; for example, to just select column A.

You can execute SQL scripts with this step using either of the following methods: Execute the SQL script once, during the initialization phase of the transformation. Execute the SQL script once for every input row that is sent to this step.

Jul 7, 2017 · It makes easier to track changes on Subversion, and in case of need I can just open the sql file on DB manager and execute it directly. How could I do that? I suppose I could use some component to read a txt file into a variable, and another component to take that variable and execute it on DB.

I'm new to spoon and I've been using Holowczack's tutorials to get a feel of how PDI works. I have a scenario where I would like to run an update script after a table input and table output job, can anyone assist? I have tried these four but I can't seem to figure out how to make them work. Here's the scenario...

Jul 18, 2011 · You can export from SQL Server to a text file using C#. You could also perform a similar task using Visual Basic. In this example, we will use the Script task included in SSDT.