I want to make sure I'm doing this right, I have a stored procedure that I want to run and put the results into a csv file. Is it as simple as using tDBSP to tFileOutputDelimited? Also the folder destination for the tFileOutputDelimited component will be going onto a remote server and a shared drive. Is there a component I need to use in a prejob to make that connection?
Yes you can use tDBSP to run the stored procedure and can store the result in output parameter and write the values in the tFileOutputDelimeted.
If you are thinking of using shared drive then it will work as target only in your Talend Studio, but if you want to run it also in the TAC server then you need to use the tSamba component. It is a user defined component which you can find in the Talend Exchange
