Best practice? Database to JSON

[Anonymous]

Hi all,

What is the best practice for following:

I have a SQL Server Database.

I need a JSON.file as target



Input-tHmap - jSONwritefile?

I don't seem to understand how to set the fields in the data mapper of the tHmap?

Thanks for the help!

[Anonymous]

Hi 
It is a general DI job:
tMSSQLInput--main--tWriteJsonField--main--tFileOutputDelimited

Best regards
Shong