DSXchange

If you are having multi-node environment, make sure that DB2 instance is catalogued on all nodes.

ODBC stage is also giving same error..

Hi, When trying to connect to MySQL server , I am getting error "Connections to MySQL Community Servers are not supported. Please contact MySQL to obtain a MySQL Enterprise or Commercial". This is the first time we are trying to connect to MySQL from ETL. I did search on this error message...

Did you see any extended property 'Microseconds' in your ODBC connector stage for that timestamp column. If yes, please enable it and try.

Did you check in your error tables ?

Are you trying to load into empty target table ?

Because you have selected the operator as 'LOAD_TYPE=LOAD' which is equivalent to fast load and it will load only in empty tables.

oops.. my bad. Sorry craig. I did not notice that.

It is marked as RESOLVED. Post your resolution please.

Try with this, which is having all in lower case.
StringToTimestamp("2015-01-01 11:11:11",'%yyyy-%mm-%dd %hh:%nn:%ss')

Check whether this post helps you.

viewtopic.php?t=143239

Can you see all records are passing to target in your designer window(through performace stats) . If yes, add a reject link to target connector stage and check. Also check in director log for any messages related to rejects.

Why do you want to enable parallel synchronization while loading tables through TPT. I believe you are using multi-load and it will be faster if you try to load normally.

Are you getting this message everytime when you are running ?
If you export with executables to other regions, I dont think it will ask for compilation again.

You need to implement 2nd step which Ray mentioned..
"Then you can use a stage variable in a subsequent transform stage to count up rank and ...."

Are you using UPDATE or LOAD in your load method. In otherwords, are you trying to implement M-load or Fast-load. If you select UPDATE (M-load) then whatever given in Pre-SQL wont get execute. There are some limitations in both utilities. Depends on the requirement you need to decide which one to use.