{"id":4214,"date":"2014-03-30T09:24:00","date_gmt":"2014-03-30T09:24:00","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2014\/03\/30\/passing-flatfile-non-xml-format-into-orchestration-collection-of-common-programming-errors\/"},"modified":"2014-03-30T09:24:00","modified_gmt":"2014-03-30T09:24:00","slug":"passing-flatfile-non-xml-format-into-orchestration-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2014\/03\/30\/passing-flatfile-non-xml-format-into-orchestration-collection-of-common-programming-errors\/","title":{"rendered":"Passing flatfile (non xml format) into orchestration-Collection of common programming errors"},"content":{"rendered":"<ul>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn Hi, I am new to the BizTalk world, and I have some issues hope can seek some help from the experts in this forum. I have a integration services package that unzips a zip file then load the data into database from the file. Now I need BizTalk to monitor the folder so that whenever someone drops a zip file into the folder, the package will be executed automatically. My problem now is how do I make BizTalk orchestration accept a flatfile that is not in XML format? I tried a few different ways such as having System.IO.File or System.Xml.XmlDocument message type but didnt have luck. Can someone please guide me on how BizTalk handle this scenario? Thanks in advance.<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn1 Hi,There are two important things to take into account when receiving non XML messages in an orchestration:1. Use passthrough pipeline. Do not use XmlReceive pipeline as this considers the incoming message to be XML.2. Use System.Xml.XmlDocument in the orchestration for the message you receive.<\/p>\n<p>Of course there might be good reasons to do it this\u00a0way but it looks like using BizTalk server just to trigger a SSIS package seems a bit<\/p>\n<p>cumbersome. I don&#8217;t know your exact scenario so I might be very wrong here.<\/li>\n<li><img decoding=\"async\" src=\"http:\/\/i.msdn.microsoft.com\/dn186180.LOGO_Win1211(id-id,MSDN.10).png\" \/><br \/>\nmsdn2<\/p>\n<blockquote><p>My problem now is how do I make BizTalk orchestration accept a flatfile that is not in XML format? I tried a few different ways such as having System.IO.File or System.Xml.XmlDocument message type but didnt have luck.<\/p><\/blockquote>\n<p>You have two options for getting a flat file into an orchestration:1. Create a flat file schema for it, that matches the input file (and possibly a unzip component as well?). Then use a custom pipeline with the flat file disassembler to parse the flat file at runtime, which automatically creates XML. Let your orchestration receive a message of this type (the schema you ahve created). And bind the orchestration receive port to the physical port.2. Bind your orchestration to the physical receive port, and receive a message of type System.Xml.XmlDocument. I know you wrote that you tried this allready, but you must have done something wrong, since this is how you do it.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>msdn Hi, I am new to the BizTalk world, and I have some issues hope can seek some help from the experts in this forum. I have a integration services package that unzips a zip file then load the data into database from the file. Now I need BizTalk to monitor the folder so that [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4214","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/4214","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=4214"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/4214\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=4214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=4214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=4214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}