Hi there
I'm having troubles using a task output as parameter in the next task.
It has worked for me before, but now a lot of my automatet jobs fail.

I have a SQL task that returs a series of numbers.
12345
67890
14780 ect
I need the output to look like this, så it can be used i the next sql task
'12345','67890','14780'
I use these output settings
Field separator: Comma
Text wualifier: '
Line break: Comma

It has worked well before, but all of sudden the output looks like this:
'12345','67890','14780',
See that final comma?
That f....up my next SQL task that looks like this:

Select *
from mytable
where param in(output from the first sql task)

Error message: Exception in Task: ERROR [42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'.

Can you guyes help out?
Any clue to why the extra comma and how to get rid of it?

Thanks in advance

Which version are you using? This doesn't appear to happen in mine (8.1.1)

Hi Al355. I'm using 8.3.1

Yes, it is an issue in that build. Please upgrade to the latest.

---

Hi Henrik
I'll upgrade - thanks 🙂