I am currently working on a process where, we read swift messages from the IBM Wegbsphere Messeaging queues and convert the messages into files, and finally imports the files using a third party vendor tool(the code for which is not in our control). So, what we need here is something that can free us from the whole process of creating files and importing them using the third part tool, so that we can directly import the files from the queues to the database. I belive the SQL server Service broker would we the thing which we would require(our underlying database is SQL server 2008).As far as the third party tool is concerned we can write our own scripts to import in the db directly. So we just need to integrate the IBM websphere MQ and the SQL servie Broker. I may be wrong with on the way of approch, but pointing me in the right direction would be a great help.
BTW we also need something to check for the duplicate Swift messages , if any help in that , would a be marvolous help to be greaful off.
Thanks so much in Advance!!!!