DSXchange

Ray, When I said, performance, I meant if there would be any overhead. I think you answered my question already. I guess, we will go ahead install NLS and NOT enable it. This way we will not have any overhead and someday if we actually need to use NLS, we have the flexibility to go enable it. Thanks...

Hi all, We are migrating from 7.5.2 to 8.1 Right now, we have no need to load any foreign languages, But we dont want to close our options to go that route in future. We are deciding whether we should go for NLS or not. - Is there any performance hit by installing NLS ? - Can we install NLS and not ...

Wonder why the design which I suggested did not work for you?
Probably it just needed Ray's touch.

In the above design, all the Routine_Activities should kick off simultaneously.
Can you provide details as to what is not working?

Welcome Aboard! Set the "Null Field Value" property in the sequential file for the 3rd field to "". You will find this property in the "Format" tab of the sequential File stage. P.S. Try doing a search before you create new posts, most of the answers are already answered!

If you place all these activities in the Job Sequence as is, stick in a Sequencer_Condition linking all the jobs with an "ALL" mode (Followed by a Notification Activity if you need) you should be good.

What happens if you try and re-import it? (This time not as "readonly")

Craig,

Best of luck on your conversions and set-ups.
And get back soon

My 2 cents...

Try giving a DOS command in the routine.
Something like

This should find all the files starting with RT_LOG in the current directory

Oops did not check the Version.. My bad.

Is it ok if you do not do the conversion from varchar to char? Then the TrimLeadingTrailing function would work.

Hereyou go ...

Yes you will have to copy the hashed files to the new location. There is no import/export utility for this purpose. From what I see, your hashed files are not very large. Not sure why the performance is so poor. I would try and use the default options while creating these hashed files and check the ...

reachmexyz wrote: tail -1 test.

Loose the filename, and put only tail -1 as your Filter Command

Attu, What is your source? Database/File? What is the size of your hashed file in question? You would want to resize the hashed file only if you suspect you are exceeding the 2 GB size limit. Also I would not preload to memory if the size of the hashed file is very large. If your source is not a fil...