DSXchange

Other than that one error message, there is no other message related to this.

I don't see an ORA error in the Director log. I know that my target ORAOCI9 stage is taking the value as a string and trying to insert into a number(4,2) but I am trying to understand why no ORA error is produced.

The ORA error is what I saw when I took the SQL to Oracle. It was not there in the Director log. Sorry about the confusion.

Yes, it was a data issue but I have a question. The error is being caused by the target ORAOCI9 stage. Why does the message say "Inserted value too large for column, row rejected"? The error is not caused by Oracle so no row has been inserted yet. If an attempt has been made to insert into...

I have decimal values going into a number(4,2) column in Oracle. The job has been running fine for years. In the last run, it suddenly started giving ora-01438. Is it possible that some setting got changed?

Ray, can you please explain your solution a little? For @INROWNUM=1 and 2, the key has to be 1. For @INROWNUM=3 and 4, the key has to be 2 and so on. Also, 2 is an example number. It could be some other number as well such as 5. I am having a problem in getting equal number of rows for each key. The...

I have a job with a transformer in the middle where rows are coming in. The first column is an integer column starting with 1. I would like to output integer value 1 for the first two rows, 2 for the next two rows, 3 for the next two rows and so on. I can use other stages as well if needed. Any ideas?

After Import, I get the same values. Job runs fine. No errors, no messages. Just the data doesn't get moved.

I did not contact support because the process is very complex in my organization.

rkashyap, can you tell me, on the unstructured data stage, during reading - that is on the Output tab, what values you have for your columns for SQL type, Extended, Length, Scale, Nullable etc.?

It seems like rkashyap has been able to make it work so wanted to hear from him.

The job works fine now but does not move any data. I get a message like this, "The length of column Col1 cannot be validated because character set conversion is involved. Truncation may occur without warning". This is not an error in the log but just a message. Seems to be a NLS issue. Any...

Ok, I gave up the idea of loading data from multiple sheets. kashyap, the link you gave has the same steps as the ones in the "Guide to Extracting Unstructured Data". Anyway, I set up the job to load from a single sheet spreadsheet. I followed the steps given in the document. Job runs fine...

It works when I have just one sheet in the whole spreadsheet. It is on Linux.

If I don't have anything in the "Sheet names to skip" and I want to read from the 2nd sheet and I specify its name in "Range expression", I get the error:

com.ascential.asb.cas.shared.exception.CASSMDIException

rkashyap, thank you for your response. I have a spreadsheet with two sheets. I would like to skip the first and load the data from the second. In "Range option", I tried "Specify the entire data range" and "Specify the start row". Under "Range expression", I h...

FranklinE, thank you for your response. I am trying to automate this process and having to rename each sheet with an underscore for a space would defeat the purpose.

I am trying to hear from someone who has actually loaded an Excel file directly into Datastage on an Unix platform.