This looks like a pSQL error to me, not NiFi specific. Maybe you try to insert into a table that doesn't exist (typo?) or the number of columns doesn't match I think this will help you https://stackoverflow.com/questions/36439305/error-the-column-index-is-out-of-range-1-number-of-columns-0 ... View more

Yes, I meant PutSQL ... View more

The simplest solution at least for SQL Server is using the PuFile processor and simply putting your EXEC or EXECUTE statement in there. Look at my other answer here to see how to configure it and an example.   ... View more

Very old question, but since googling led me here I'd like to share my own perspective with others who arrive later.   The simplest solution is using the PutFile processor. You can simply enter your EXEC or EXECUTE statement, see screenshot and T-SQL code below:  I used this sample code to test it:  USE [your database configured in the JDBC Connection Pool];   SELECT GETDATE() AS currentdate INTO dbo.testtable; GO   --procedure used in NiFi PutFile processor CREATE PROCEDURE dbo.insertdate AS BEGIN   INSERT INTO dbo.testtable   SELECT GETDATE(); END GO ... View more