Thanks for that, however I realise I didn't really highlight the main issue.
In your sample, and the online help the DBOutputWriter uses the syntax:
Code: Select all
Insert into table(col1,col2)
values ($col1, $col2)
This syntax is not acceptable for the SQL Server 2008
database I am using. I checked on wikipedia, and it appears valid for other databases such as Oracle but not SQL Server. Do you know what the equivalent SQL Server syntax is?