05-12-04 01:21 AM
Hi,
I want to set/change the OutboundTransportLocation property. I mean, I want
to set destination folder and filename in runtime.
The case :
I receive flatfiles in several folder. Each system has its own folder. The f
iles must be picked up, mapped from one flatfile format to an another and se
nt to a destination folder. The destination filename must be on this format
: <two character system ini
tials>YYYYMMDD<one digit counter>.sdv (sample : IM200405110.sdv). Receive ma
x 10 filer per day. Info about destination folder must be read from registry
. The filename must be available in the map.
I plan to solve it like this :
Get flatfile from receive folder, create new filename with db interactions i
n flat file receive pipeline (need to do db interactions because info about
the current counter value is stored in db), read destination path/folder fro
m registry in receive pipel
ine, set OutboundTransportLocation property = path + new filename in receive
pipeline, set promoted schema property = new filename in receive pipeline,
map file (use promoted property/field when mapping), send file to destinatio
n folder with new filename
through a flat file send pipeline.
Questions :
1. Is it ok to do it like this?
2. How do I read/set the OutboundTransportLocation property in a receive pip
eline? Method? What namespace?
3. Must I use "Dynamic one-way-port" in the send port when changing/setting
the OutboundTransportLocation property?
I really hope you can help me!
I use VB.Net so if it's possible to get samples in VB.Net it would be great
Regards,
Cecilie
[ Post a follow-up to this message ]
|