webSphere MQ Queue Issue

Home Page Forums BizTalk 2004 – BizTalk 2010 webSphere MQ Queue Issue

Viewing 0 reply threads
  • Author
    Posts
    • #25832

      Hi All,

      I have input file like below and it is a flat file.

      VGBE;11635;PR;20090121135330;5000304506;         10.00;          0.00;;EA;        368.40;         63.09;        368.40;         63.09;;20100816132759;N;         10.00;
      VGBE;11635;MT;20100304122046;4900263382;          2.00;          0.00;;EA;        368.40;         63.09;        368.40;         63.09;;20100816132759;N;         12.00;
      VGBE;11635;MT;20100304122048;4900263382;             0;             2;;EA;        368.40;         63.09;        368.40;         63.09;;20100816132759;N;         10.00;
      VGBE;11635;IM;20100304131303;4900263394;             0;             2;;EA;        368.40;         63.09;        368.40;         63.09;;20100816132759;N;          8.00;

      and i have to have outfile as given below—-this target i have achieved by implementing a map.

      ERONOVGIBERBE11635          PR200901211353305000304506000000000100000000000000000000000000000EA0000000036840000000000630900000000368400000000006309NOK   20100816132759N00000000001000
      ERONOVGIBERBE11635          MT201003041220464900263382000000000020000000000000000000000000000EA0000000036840000000000630900000000368400000000006309NOK   20100816132759N00000000001200
      ERONOVGIBERBE11635          MT201003041220484900263382000000000000000000000002000000000000000EA0000000036840000000000630900000000368400000000006309NOK   20100816132759N00000000001000
      ERONOVGIBERBE11635          IM201003041313034900263394000000000000000000000002000000000000000EA0000000036840000000000630900000000368400000000006309NOK   20100816132759N00000000000800

      I have developed receive and send pipelines to achieve desired format. using my schemas.

      Now the issue is:

      When i do File to File transformation, records are getting generated properly. But my business scenario is Flat file to Mq Queue so when i configure file adapter for recevind input and MQ adapter for output, records getting converted properly but they all go in one line to destination queue. actually it should have been in 4 lines i.e 4 records.

      Do i have to do 1st Flat file to Flat file conversion ? and Flat file to MQ queue next? if so what pipelines i should use?

      I have tried doing Flat file to MQ with Pass through piepline but records does not go at all to required queue.

      Regards,

      Bhupal.

Viewing 0 reply threads
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.