DSXchange

It worked :D I created a script which would fetch header information from the file and create a schema file out of it. Then I used this schema file to read the input file using sequential stage and RCP. Luckily, we do not need to do any transformation on these columns, so I guess weare good with RCP...

Thanks Craig. Please let me know if you see any issues for the below approach: Job 1 -> Read the header information and create a schema file using it. Job 2 -> Use this schema file and read data from the file using sequential file stage. The challenge that I see here is, we may not be aware of all c...

RCP cannot handle column ordering?

Hi All, We have a requirement wherein we load data from a flat file (csv) into a table. However, the format of this source file is not fixed. Columns may not come in the same order always and we can also get additional columns in future. Eg: 1st day my file will be: EmpId, BirthDate, HireDate, DeptN...

Thanks everyone. I will check with the support.

Regards,
PR

Tried running my job on one node and also tried to run it after adding the environmental parameter but still it is stuck at the same place.
Do you think if there are any ways to debug this job and see where it is stuck?
Regards,
PR

Just to ensure it is not DB related issue, I removed Oracle stage (target) and replaced it with a dataset. Still I face the same issue.

No warnings. I have to kill the job in the end. Everytime it only loads 30K records.

Hi All, I used "Unstructured Data" stage to read from an excel file. It ran perfectly fine for the first time. I got another file to load and when I ran the same job, it hangs everytime after loading 30,000 records (this file has a little more than 32K records). I tried to debug the proble...

Forgot to mention MYSQL version. It is 5.6

Hi,

Thanks for the information.

I had checked this but since this query works fine from all other clients, my DBAs think it is ODBC driver issue.

When we fire this query on other clients, it gives us desired output.

Regards,
PR

Hi All, I am connecting to MYSQL database through ODBC connector. I managed to connect to MYSQL database but everytime I execute a select query it gives an error: ODBC:1615 [IBM(DataDirect OEM)][ODBC MySQL Wire Protocol driver] [MYSQL]Prepared statement needs to be re-prepared. I checked with MYSQL ...

Just a correction to above post. For the successful connection, we do have # character in the password. Password is something like $#abcd#$. This job connects to MYSQL without any modification required in password field. It is only when password starts and ends with a #, we face this issue. We do kn...

Hi Ray, I replaced # with __035__ and checked but it is still not working. Our password also contains $, I replaced that too with __036__ but still getting same error message. I am connecting to a MSSQL database using ODBC connector. For another connection, password contained $ but no hash character...

Hi All, My password is having # as a starting character and as an ending character (e.g. password is like #abcd$#). I am using ODBC connector stage to connect to a SQL Server database. I am getting below error: Invalid property value /Connection/Password (CC_StringProperty::getValue, file CC_StringP...