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 …

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 * …

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 …

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 …

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 …

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 …

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 …

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 …

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, …

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.