Hi,
I am trying to use output tool to connect to my sql server i have to save my table on server under specific folder or directory. How to give that path in output tool or how to save table in that directory ?
Thanks,
Aakash
Akash_on,
You can specify exactly where you want something by creating field with the path in it in the formula tool. Then you reference that path in the output by switching the 'full path' using that field.
I used an excel output, but you can modify the concept for what you need. I also just put in 'dummy' data for a directory and folder, just use your own for the actual path.
The Account running your workflow requires explicit access to the folder at the server where you want to write output; If you publish the workflow to the Company Gallery, the Gallery's service account also need access to that folder-server.
hth
Arnaldo