I've found the problem if anyone is interested.

Write-Output limited the result set to the size of my powershell window which meant the second half of the output was put on...

It appears the variable is passed through, however.......

I changed the SQL Task to:

INSERT Test

VALUES (?)

so that enabled me to see the variables value in a table.

However, there are two spaces...