DSXchange

I don't see how 'matches' can get you the last occurance, at least not easily. Perhaps Ray knows some magic for that. :? Me, I would build a routine that does the 'looping' you asked about. Check the length of the string, execute a For loop stepping from that to 1 step -1, use substring at that posi...

I got at least 20 matches when I searched for that message, did none of them help you?

evee1 wrote:I know that containers will run slower so I would not want to go down this path in the long term

There's nothing about having things in containers that affects speed, they're just logical blocks of code that get compiled into the job.

Did you try enabling the 'Include job status in email' option? That should pull that error from the log into the email body.

They are usually read only for a reason. Are you sure you're in a project where they really should be edited? If so, any idea how they got to be read only?

Have you been able to use the DRS stage successfully before (SQL Server or others) and just have a problem in this one job, or is this your first attempt to use it?

Do you know the maximum number of non-key columns the file could contain? Is that your 9?

You really shouldn't have to do that and even the help for DSSetJobLimit tells you that. I assume you're actually running the batch job from Director, not the command line using dsjob, right?

Please explain what you mean by a "job control batch". Is this hand code using the DSRunJob() function?

Sure there is, you just need to do the 'dynamic' part outside of the job (for example, leveraging a Sequence) and then pass it in as a Job Parameter. That parameter can then be used in the FTP stage.

Try adding in... what the heck is it... the "/B" option and see if that helps.

In DataStage use the following to convert your static date value to the same format as the date in your timestamp: OConv(IConv(YourField,"D"),"D-YMD[4,2,2]") Then compare that to the first ten characters of your timestamp using YourTimestamp[1,10] . If this static string is comin...

Post a sample of the actual unedited errors.

First try using single quotes (') rather than that accent mark (`).