DSXchange

In My Humble opinion the deprecated issue might be resolved by recompiling the job.
especially if you imported ajob with the executables.
Usually this means that this option was replaced with a new one and will no longer be supported in future releases.
IHTH(I Hope This Helps)

Hi, My guess would be you have a job parameter named type according to it's value the 2 user variables get theier value set, If type = 'A' both are set to 'where 1=2' (like saying @FALSE, it never happens) and if type <>'A' the first is set to an empty string and the second gets " CC" But ...

Hi, The shared container incoming or outgoing links must be defined twice. once in the shared container itself and the second time in the job design that uses the shared container. those links 2 for input must be defined with the same metadata and the 2 for output also must have te same metadata. So...

I agree with Craig. Considering you said 28 million records I guess you hit the 2GB limit on the Hashed file. Bearing in mind there could be also a ranged lookup that might be an issue. To make a long story short, I think you can simply load your 30K records to a temporary table and use a simple sel...

Craig,
I beg to differ!
In my humble opinion (from experience) any hashed file that is used for a long period using the clear option never being deleted and created a new, is bound to eventually get corrupted.

When you test your routine via the designer you get the NLS setting from your client machine. When you run the job it uses the server setting defined in the default project/job/stage setting it runs with. 1252 is english as far as I can recall. if your specific version doesn't include the pound sign...

I failed to understand the question , sorry.
Can you please try to rephrase it?

When you create the hashed file/s you are better off deleting and recreating them (if possible) for this (amongst other) reason.
IHTH... (I hope This Helps)

Hi, Can you please double check that the jobs you are trying to open were imported with the export file! and do exists inthe project There is a chance that you ommited read only objects and they were read only, causing you to have a sequence tat tries to run a job that doesn't exist in the project. ...

You need to examine you configuration files. There might be several files, so ask your admin guys...
In fact the number of nodes is dynamic and depends on the configuration file.
Or do you mean how many servers are linked together?

Well got it working (hoping fine ths time ;)) The catch with writing t Seq File is that I had to set the NLS to unicode using the right side check box "Use UNICODE map" and unchecking the other 2 checkboxes. Now I'm waiting for test results to confirm (hopefully) a successfull test. P.S. I...

Notepad++ has a plugin utility for encoding & decoding of base64. since when I use it to decode my source string in UTF8 it shows fine I expect opening the file I built and see the desired outcome. Though my last test leads me to believe I still need to fix something in my logic... We'll see tom...

I got to calculate the unicode number for my specific character.
But still UNICHAR(55184) (i.e.) dosen't seem to get me the desired effect.
Using notepad++ I should be able to see it correctly when I write to a sequential file using UTF-8 NLS setting , no?!

Hi All, I'm trying to represent Local NLS characters in a UTF8 string. These characters are a result of a Base64 source code. English translates fine, but, local characters are not. So I'm getting a source string with only A-Z,a-z,0-9,+-= as the input characters (for those not familiar with Base64) ...

Check if you have privilages to where you need (project's instalation directory and such) My guess would be you have no privilages in the directory that your projects are on, where dsadm is concerned. As for the other users they have no privilages also in the installation directory. But those are on...