orchestration
Wed, 15 Mar 2006 09:43:27 -0800
Hi everyone...
I have two question!
1- I have this SP:
CREATE PROCEDURE _select_mail
@istat CHAR(6)
AS
SELECT email
FROM _flusso_mail left join _fatturatore ON _flusso_mail.codresp =
_fatturatore.codfatt
WHERE _flusso_mail.istat=@istat
for xml auto, xmldata
And then I have thi ...
|
How to get flat file parser output ASCII not unicode?
Fri, 10 Mar 2006 13:32:49 -0000
The flat file parser always seems to output flat files in to XML in unicode
format which doubles the size of the files. Can I instruct it to output as
ASCII/single byte instead?
--
McGeeky
http://mcgeeky.blogspot.com
...
|
BECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K.
Thu, 9 Mar 2006 15:43:14 -0500
...
|
Positional Schema alludes me
Thu, 9 Mar 2006 10:10:28 -0800
I would like to define a schema for a positional file that has 3 record types:
H - section header
W - detail header
T - detail record
The file can contain multiple sections, and within each section there can be
n detail headers with n detail records. For example:
H...
W...
T...
T...
W...
T...
H... ...
|
Send mail
Thu, 9 Mar 2006 09:26:27 -0800
Hi everyone....
I have the following problem:
"I must send a mail to different addresses".
I have this stored procedure:
CREATE PROCEDURE _select_mail
AS
SELECT _flusso_mail.idflusso, _fatturatore.email
from _flusso_mail left join _fatturatore on _flusso_mail.codresp =
_fatturatore.codfatt for xml au ...
|
Biztalk 2004: Flat File Validation
Wed, 08 Mar 2006 08:14:12 -0800
Greetings all,
I seem to have encountered an issue in regaurds to a flat file.
I have created a schema of the following format
FlatFile (child delimiter 0x0d 0x0a, postfix)
Row (1 -> *, child delimiter 0x2c, conditional default)
Field1 (min & max -> 1, xs:string)
Field2 (min & ma ...
|
Inserting the message length in the header
7 Mar 2006 05:01:19 -0800
Hi,
I'm interfacing with a flat-file messaging system calling from BizTalk
2004. The main body of the message is tab delimited, with tag
identifiers on each line. I've got this part working fine.
My problem is that each message must include a 32 byte header with 4 by
8 byte fields:
user id
password
tra ...
|
|
|
We Pay 50%--100% Returns Monthly For 1 yearr on investment. You need to know this!
Mon, 6 Mar 2006 21:50:55 -0500
...
|
only test- solo test
Sun, 5 Mar 2006 12:19:31 +0100
...
|
BizTalk debatching
Sat, 4 Mar 2006 14:04:27 -0800
Hi
I have the following CSV flat file:
A0,CLIENT 1, LOCATION 4
A0,CLIENT 2, LOCATION 5
A1,CLIENT 3, LOCATION 6
A1,CLIENT 5, LOCATION 7
A3,CLIENT 6, LOCATION 8
A3,CLIENT 7, LOCATION 9
I want to create individual messages based on the first field. In the
example above the end result should be 3 xml ...
|
