We are trying to design an interface where
a) we will periodically update the Database using CSV files, and
b) periodically download all the contents of the database to a CSV file format with a fixed filename
We created a Message Set for the CSV file and could get it working (insert data into the table). But we are facing issues while downloading the entire contents of the database into a single CSV file. (We could get the flow working for a XML output).
If anyone can help with a solution, it would be much appreciated.
MB Version : 184.108.40.206
Database : DB2
Database COntent :
Two Columns : Column1 and Column2
Desired Output : Filename : Filename.txt (Fixed)
File Content :
ValueM, ValueN, etc
Pinned topic Database to CSV File question
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-11-16T14:56:11Z at 2012-11-16T14:56:11Z by firstname.lastname@example.org
email@example.com 120000CJSH515 Posts
Re: Database to CSV File question2012-11-16T14:56:11ZThis is the accepted answer. This is the accepted answer.Not possible to diagnose the problem based on that information. We will need to know what you tried, and what happened. 'We are facing issues' doesn't really convey the picture :-)
I assume that you are using the MRM parser with a TDS format to write the CSV output, so there should be some error messages telling you what went wrong.