Viewing 6 posts - 1 through 7 (of 7 total)
No I had completely deleted the import into the table. It was 2 steps... Flat file source, and data conversion.
In the meantime, here's an update. I got it working. Just...
April 17, 2020 at 11:58 pm
OK I modified the flat file to include only 1 row where the new fields are not null. Same results 🙁
April 17, 2020 at 3:32 pm
I thought is was NULLS also but many of the other date fields have NULL values and they are fine as well. The data I posted above used another date...
April 17, 2020 at 3:09 pm
OK I ran it within VS:
Error: 0xC02020C5 at Res import, Data Conversion 1 [2]: Data conversion failed while converting column "VOPENDATE_op" (1545) to column "VOPENDATE" (527). The conversion returned status...
April 17, 2020 at 2:42 pm
Phil
Thanks for you efforts so far.
I see how to enable data viewer on the pipe prior to conversion, but where do I actually view the data? I design the package...
April 17, 2020 at 1:51 pm
Here are 2 records. The first is a record that has data in the new fields and fails. The 2nd is one that imports correctly. If I change the data...
April 17, 2020 at 12:07 pm
Viewing 6 posts - 1 through 7 (of 7 total)