[community-content]

Cool – do you have to purchase it or can you see how it works?

[community-content]

I've been looking for the same.  Please let me know if any one has it…

Thanks,

Divya 

[community-content]

Jeff Lynch wrote a custome pipeline component used for archiving purpose, you will find it's very useful.

[community-content]

Figured it out. I didn't set up the schema properly, after adding tag for Header and Line items and using Looping, the value in Header is correctly copied to all Lines belong to it.

 Thanks

[community-content]

What are your specific mapping requirements here?

I would like to help but I'm not sure I understand the pattern.

[community-content]

CREATE PROCEDURE (Transact-SQL)

CREATE { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ] 
    [ { @parameter [ type_schema_name. ] data_type } 
        [ VARYING ] [ = default ] [ OUT | OUTPUT ]
    ] [ ,...n ] 
...

[community-content]

BizTron,

where does one specify the OUT parameter?  In BizTalk I'm calling the Sproc stored in the SQL Server, but all the examples I've seen seem to define the OUT parameter when they create/execute the proc as part of a select statement – see the code example under the "Output Parameters" section: http://www.awprofessional.com/articles/article.asp?p=25288&seqNum=9&rl=1

Thanks for your help.
 

[community-content]

Is the Xsd type for "ns0:EX_SOR_NUM" xs:int?  If so, I would suspect your error is from validation.

If it's string, I would suspect you are receiving an Oracle error.  Can you confirm and respond with any errors related to this issue?

I haven't had any luck calling functions directly, but sprocs within a package (Oracle 9i/10g) work fine.  The Stored Procedure approach could be an option for you, but I'm not yet sure if you can achieve your desired results of passing a function directly.  I'd like to try it myself and see if we can compare notes.

[community-content]

BizTalk Server 2006 Administration Console…
—————————————-
Console Root
  BizTalk Server 2006 Administration
    BizTalk Group […]
      Applications
        <Your Application Name>
          Send Port Groups
          Send Ports

[community-content]

Biztron,

I think that would work for our needs.  I'm trying to grasp what you mean in your last sentence, I'm not sure where ports and port groups come in so I need to read up on it.

Thanks! 

 

 

[community-content]

the data in config file is like

 <emp>
      <data id="1" />
      <data id="2" />
 </emp>

I use AppSettings.GetValues("emp"). This returns string array (i.e) String.String[]. i need to loop to find the exact row. for that i need String array. Ordinary Array does not help.

[community-content]

Hi

Please also explain in detail regarding creating custom pipelines. I am new to biztalk..Please guide me.

[community-content]

Hi Nishil

I have created watever you have written but could you please tell me the configurations of the logical and physical ports coz i guess that is creating a problem and my file is not reaching the destination.the orchestration is getting terminated and error msg is"the instance was terminated by the user".

Please reply.

Thanks in advance.

[community-content]

You can easily Create the Schema for the input text file…child delimeter ~.

U can use custom pipeline for Flat file disassembler.

Inside Orchestration you need to get the  "D"value and "Salary" by Xpath.

There is a terminate shape .You can use that.

Its as per my understanding

[community-content]

Is that your requirement to return a string array from appsettings.

You can return a single string from AppSettings.

I think u need to create a variable and refer it to System.Array…..its inside Mscorlib…system.

Not sure just try it out.

[Author]

Posts