| Cecilie 2004-05-11, 8:21 pm |
| 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 files must be picked up, mapped from one flatfile format to an another and sent 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 max 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 in flat file receive pipeline (need to do db interactions because info about the current counter value is stored in db), read destination path/folder from 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 destination 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 pipeline? 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
|