DSXchange

Stage variables.

Write out the logic in English, and the stage variable initialization and derivation expressions will magically appear in your brain.

Its very Urgent. We don't do "urgent". DSXchange is an all-volunteer site whose members post when, as and if they can. If you need "urgent" sign up with your official support provider for priority service, and learn just how expensive "urgent" is. You posted this at 2a...

DfloatToDecimal()

So what's the fate of whs_datamsk(C) in record #1?

Moderator: please move to Server forum

You may not have to move them at all. If your job stream creates the hashed files, you can rely upon this happening in the new location. I suggest running jobs in Validation mode in the new location.

Please make a post telling us, and future searchers, HOW you resolved this issue.

The real question is whether your client machine can resolve the IP address of csgetl server. Can you successfully ping csgetl ?

The access denied is probably in the XMETA database. Can you check whether there are any entries in the XMETA.XMETALOCKINFO table?

Please mark this thread as Resolved using the green button at the top of the page.

Yes it can be locked even though it's not open, but that won't achieve anything other than preventing others from opening it, which making it read-only would also achieve.

Can you have the scheduler script ECHO the command so you know exactly how the variables are being passed?

I believe that, of the options listed, Fmt() would be most efficient.

IsNull() returns 1 or 0.

Therefore IsNull(col1) Or IsNull(col2) Or ... Or IsNull(col25) will return 1 if any one or more of the columns is null, and 0 otherwise.

What definition are you being asked to edit, and who's doing the asking?

Don't call DSGetLinkInfo() for every row - it's too great an overhead.

Get the count after the job has finished, for example in an after-job subroutine, in a Routine activity, or using Kim's ETLstats package.