DSXchange

I do this in 2 steps. The first job posts the result to a hash file then this routine reads from this hash file and sets a parameter value. All jobs in this sequence which start after this routine activity will get the new parameter value. You can modify this routine to get the value from what ever ...

I have been thinking about this for a while now. I think it is possible to build this utility. I think it would be easy to start with sequential nad hash files. Lets say you find all jobs that read or write to a specific hash file and compare their metadata and show all discrepencies. I would think ...

You can change your metadata to be nullable. You could change your derivation to check for null.

if IsNull(input.column) then "default value" else input.column

"Stage Name" has to be the name of a real stage in your job. Same for link name.

I think all you need is to add the time like

NewDate = OldDate : " 00:00:00"

Do a search for iconv or oconv

I think there are routines for SQL Server dates included in the SDK. This topic has been covered a lot. If you do a search and still cannot find it then let us know. I think you are missing the time portion. It is a timestamp in SQL Server, correct?

Craig is correct. Where you import your columns from is buried in the DS_JOBOBJECTS records. You could hack it. It just shows you the original import name from DS_METADATA. I am not sure if you import again if this gets over written or tracked separately. In doc_tool.mdb all the columns for all the ...

You could also hack the DS_JOBOBJECTS file. Of course this may violate your license agreement but how do you think we learned it.

We have one job which populates this table. It has several parameter but 2 important ones.

select max(#SurrogateKey#) from #TableName#

The key to SDKsequences is the parameter SurrogateKey.

Change it to a UV stage. You can do any kind of SQL against it then. Another way is to exec a TCL command and give it an update statement.

Ray

I think we need a magic function here. How long is this string?

Ken

I think they want to know an automated way to change all the jobs from path to account. Is that correct?

Thanks. I need a good laugh every Monday morning. Start my week off right.

Geez Craig, trying to raise your points. We will never catch you anyway. Neat trick answering your own questions.

Thanks. And the price is right too. They are free. Tony from ASCL wrote the JobReport routine. So I cannot change where the derivations print. I wrote a wrapper so it would run it for all the jobs and I wrote the routine documentation. Also an index to all the jobs and routines. It was fun. Learned ...