DSXchange

suse_dk wrote:There is no criteria for which duplicate is choosen - it is just the first one encounted that the match will be performed on.

That sounds like criteria to me.

Yes. And it's hashed file and #1 is one.

That's going to depend on how the jobs are scheduled. For ones scheduled via the Director client, that information can be found in the scheduling user's crontab. Note that is a UNIX specific answer as that is how the post is marked.

The tranformtion code i am using is timestamp(iconv(trim(RPT)," D/2")) Not really sure what your "timestamp" function might be. Can you post some unadulterated examples of the source data? And let us know what the actual datatype of the target column is, meaning in the database ...

Googling for that error usually points to issues wit date or date/time fields. Have you verified that the values you have there are appropriate for the target datatype?

Hargun - Server job questions go in the Server Edition forum.

Thanks.

Let us know if this helps.

So... this is a Server job?

Why pass it with the quotes? Can you not simply pass the value and include the quotes in your SQL? Something like:

WHERE TABLE_TYPE = '#Parameter_Value#'

Well, at least now I know where to point if anyone ever asks me if I know someone who has turned that option on.

Sure, there are games like that you can play to expose passwords, using them in any fashion that requires them to be decrypted with passed. Forgot that little nugget.

I don't see what could be considered "illegal" about it, never mind the fact that the password is encrypted. Usually the password in question is specific to the ETL functional user, so it's not like there would be far-reaching unknown consequences to having it reset. Hopefully.

OK... so you have the password encrypted in the jobs but no-one locally knows what it is? Phil Hibbs has a utility that will (amongst other things) decrypt them, let me see if I can find it.

And no RCP in Server, I'm afraid.

Found it here: viewtopic.php?t=132851

I can't get access to the database, because nobody knows the password, even if there is password on Administrator (but it is encrypted). That's your hurdle... without access to the database, everything else is moot. So, is this a database you "own"? If so, as DBA should be able to assign ...

ray.wurlod wrote:Craig does not have access to a version 8.7 system.

Nope, just 9.1 at the moment.