hi,

I have a problem while creating tables regarding a purchase order flat file on sql database after having used the convert to values java service in the flow service. can anyone help me out with the procedure??

regards,
munna.

Munna,

Did you created JDBC Adapter connection(to SQL DB),adapter service (InsertSQL template) that interacts with SQL Server inorder for inserting data??

OK for parseFFandInsert…Once you parsed the flatfile using flatfile:convertToValues service successfully then in next steps call the above insert adapter service and perform mapping flatfile document/fields to inputs of your insert dbservice…How ever you need to build a flow service with the above logic in a wrapper flow or generic flows which you might have already in your builds.

HTH,
rMG

thanx a lot rmg, i was actually wondering how to proceed after the convert to values service…will proceed as u said n will post any doubts if any in future.

regards,
munna.

No problem…goodluck…