Reply
Member
Posts: 211
Registered: ‎01-18-2017

Re: Lab 1 - Question 2 OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

Okay, I said I had an error.. and I just want to come back and say that I have resolved the issue:

 

1. Issue is I'm doing my data cleansing in the "Transform Sample Data", the raw data has a column which is supposedly a number.

2. The sample data grabbed (this one single file among the many) has all values in that field as a number

3. Now here's the BUT..... But, the are other raw data that had a dash(-) in that column where it's supposed a number.

4. That is what caused that error to trigger.

 

Solution, add a filter (filter out "-") via Advanced Editor since via UI would not let me since it recognizes that the sample data had all number in that column, even though I inserted the step right before Data Type assignment.

 

That's it in my case.

Member
Posts: 211
Registered: ‎01-18-2017

Re: Lab 1 - Question 2 OLE DB or ODBC error: Exception from HRESULT: 0x80040E4E.

Ooops, I just realized that I posted in a very specific discussion but nevertheless I hope my entry can help someone else. Thanks for reading anyway.