I have a text file list of bad words for a profanity filter and was trying to load them.
I am trying to execute the following SQL using a TMSSqlRow component
"alter fulltext stoplist BadWords add ? LANGUAGE 'English' "
I have ticked use Prepared Statement and 1 parameter in my list which is to consume the bad words from the connector from the TMap
When I execute it I can see all words moving along the pipeline as the iterations of reading the file and passing them through the tMap are incrementing
Unfortunately, I get no stop words added to the list and the error I get is "Invalid parameter index 0.' for each iteration
I have a connection, a tinputfileDelimeted a tMap and the tMSSQLRow to do this small piece of work
What am I missing?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema