community-content

Forum Replies Created

Viewing 15 posts - 4,426 through 4,440 (of 9,648 total)
  • Author
    Posts
  • in reply to: Help on SQL Adapter – URGENT!!! #19866

    Nothing wrong with stored procs, but recursively calling a stored proc to add single rows from an orchestration will not be the most performant solution.

    The datagram solution using at-identity is good for large amounts of data that are not too complicated.

    The alternative of a stored proc to process an Xml data object is the other way of not recursively calling SQL. See this example from Leonid  Ganeline http://geekswithblogs.net/LeonidGaneline/archive/2008/04/03/biztalk-sql-port-how-to-pass-several-rows-to-the.aspx.  This uses OPENXML and will work with SQL2000 or SQL2005. If you are using SQL2005 using XQuery instead of OPENXML will give better performance

    in reply to: Detecting duplicate nodes in BizTalk #19865

     The map above will only work with the example Xml provided above. If your actual Xml is different (e.g. uses namespaces, different structure, node names then it will not work.

    Are you able to provide an example of an actual input message that you wixh to map?

    in reply to: Detecting duplicate nodes in BizTalk #19864

     Thanks greg

    I am using the above xsl in an orchestration. I selected my Items schema as input schema for map. I created a schema with only one element of type xs:anyType and used it as output schema for the map and in the map properties, I selected this file as the custom xsl path. However, it is generating a empty file.

    Am I doing it the right way?

    You could add the class project to the solution containing your orchestration project.

    Then, in the orchestration project’s references, delete the existing reference to your class, and add a new reference from project, your class project will be available on the “projetcs” tab.

    At this point,  you can set the build profile to build and deploy both objects, the class and the orchestration.

    Refresh and restart the host instance as noted each time you redeploy.  You’re good to go.

    Byron,

    You don’t need to add it through the Add Resource functionality of the BizTalk Admin Console, because it isn’t a BizTalk assembly, BizTalk doesn’t need to know anything about it.

    Just add it to the Global Assembly Cache (GAC) and restart the Host Instance that is running the orchestration that is invoking the assembly.

    Be aware that you may have updated the Assembly version of the GACed assembly, in which case BizTalk won’t be able to find it as it will still be referencing the old assembly version. If you don’t want to re-compile the BizTalk project containing the orchestration to reference your new version, keep your helper assembly on the same version number, but increment the File Version – this is just meta-data and will be ignored when BizTalk tries to find your updated assembly, which it will because the version number has not changed, however you will be able to tell that you are running the correct version.

    Hope this helps,

    Rgds, Nick.

    in reply to: Help on SQL Adapter – URGENT!!! #19861

    Personally, I’m use a Stored Procedure everytime I need to do any database work – that might be overkill, but I have complete control over the operation.

    Perform the insert into table1 in the SP and use the @@IDENTITY system function to retrieve the last-inserted identity value generated by the INSERT statement as value to assign to table2 and table3.

    More information can be found at BOL – @@IDENTITY (Transact-SQL)

     Thanks for the replies.

     

    I did resolve this by adding the assembly to the Resources folder of the application in the Administration Console and checking the Overwrite all checkbox.

    Is this a correct way of resolving it?

     

    Byron

    in reply to: Help on SQL Adapter – URGENT!!! #19859

    A better method would be to pass all the data in one updategram and use the at-identity feature of updategrams to add child records

    http://msdn.microsoft.com/en-us/library/ms171764.aspx

    Alternatively, you could send the an Xml message to a stored procedure and shred the message and update tables using X-Query (requires SQL2005)

     You will also have to rebuild and redeploy your Biztalk assembly that references the .NET assembly

    dear you have to restart the host instance as it always caches the last instance of an assembly.

     

    regards,

    Faisal

     

    in reply to: Encoding issue #19854

     

    Thank You Very Much, Greg 🙂

     

     

    in reply to: messageid in a Map #19853

     1) Promote the required field in the output message schema to the BTS.MessageID property. The Assembler will demote the MessageID value into the message for you.

    2) The pipeline components basically receive a message and return a message. The message in the pipeline is made up of a context and a stream of bytes, you can do anything you like to the stream.

    in reply to: Encoding issue #19851

    In ASCII the British pound sign is 0xA3

    In UTF16 it is 0x00A3

    In UTF-8 it is 0xC2 0xA3

    UTF-8 is an encoding that supports the tens of thousands of Unicode characters. The first 127 characters are the same as ASCII, after that all characters use 2,3 or 4 byte sequences to represent characters.

    check out http://www.unicode.org for more information 

    in reply to: Zip pipeline component #19850

     

    I juts figured out i was not respositioning my memorystream ..

     

    zipMemoryStream.position = 0;

    messageIn.BodyPart.Data = zipMemoryStream;

                    return messageIn;


    Thanks

    in reply to: Encoding issue #19848

     Hello Greg,
                 thanks a lot for your inputs.
                 however still one confusion.
           
    when you say “The British pound sign ASCII character is invalid according to the UTF-8 spec”

    Would you please elaborate on this since i am sure the pound symbol can’t be left out of UTF-8?
    I am a newbie so would appreaciate an explanation.

    thanks once again

Viewing 15 posts - 4,426 through 4,440 (of 9,648 total)