DSXchange

True but in going back through their posting history, I believe they are on 8 something.

I don't believe there is a maximum, per se. I would assume any limit will be imposed by your O/S, primarily whatever the limit on the length of your command line is. Same for the 'individual parameter' question, assuming that just means string as well. To be honest, however, it was never anything I ...

Don't take this the wrong way but if you're not skilled in all of the ways of C++ then this isn't a path for you. IMHO, you'd be better served by starting a new post and letting us know what kind of a 'string problem' you are having. Then we can suggest alternatives.

There's no such thing. But there is ...the Amazon Cloud. BYOSL, however.

Keep in mind the facts that Ray noted, Arnd's code needs a VOC entry to work. Meaning the hashed file needs to either live in a project or you've created one for it manually. If you've pathed the hashed file elsewhere, change the OPEN to OPENPATH appropriately.

ray.wurlod wrote:The OP states a requirement to do this within "a job control".

Of course but we all know how ephemeral these "needs" can be at times, hence my phrasing. And "job control" is perfectly capable of running a job.

In other words, you can use job parameters in select SQL. Since it is resolving as empty, you must have passed in a null value... that or not really passed it to the Job Activity stage correctly.

Or, on the off chance it doesn't really need to be done in BASIC - create a little Server job to do that.

asorrell wrote:Note - per your request I have added a new FAQ that delivers the Backup script that used to be a part of ETLStats

Why tanks, Mista Andy!

Seems more like a question for them to me.

Ah... 'generic job' as in RCP enabled. That complicates this. Let's see what others have to say, I'm wondering if that means some sort of post-processing task.

I thought Kim's script was posted here but I couldn't turn it up in the time I had to search for it. From what I recall it was bundled into his ETLStats package, which I'm pretty sure Ray still hosts. It may also be something I have at home, I'll try to remember to check later.

Right. You need to tell it what kind of validation it needs to do. And don't fall into the trap of thinking you can use IsValidDate instead.

They're all documented, why not start there?

As to your specific question, it is documented here.