Automatically create rowid from import excel to SQL Server

Hi Mike,

here already the Table script and the file. I have truncated the file to 25 records, as it already crashes after record 1, and as this moment I don't want to sent over the entire excel-file with 11.000 records.

Please let me know how I can extract the mapping; if that is an ats-file then please see attached as well in a zip-file.



Regards,
Norman

I am not getting any AV's on my own computer only this error

Error 11/10/2022 14:53:06 12 Writer: {Writer3}, DEMO.dbo.afleveradres Record/Line:0 Record Rejected: Field: Value '999' is too big for type TINYINT for field LOSTYD

Will try another computer.

can you post a screenshot of the about box of AETL, please
I want to make sure that we are using the same version

Hi Peter,

here a screenshot of the about (see attached).

Also I looked at the Writer-step and then on the transformation-tab, I see that the scripts tries to enter values all "?", which is not correct. When I take 5 records as example, I get the error in the Execution log saying "No value given for one or more required parameters".

I have made screenshots of this, maybe this helps in investigating? I have uploaded this as well.


Please let me know if I am doing something wrong or if this is something else...

"Also I looked at the Writer-step and then on the transformation-tab, I see that the scripts tries to enter values all "?", which is not correct. When I take 5 records as example, I get the error in the Execution log saying "No value given for one or more required parameters"."

There is no need to use user-defined SQL in your case.

Please try changing tinyint fields to int

I did that already (999 is not a valid value because it only runs till 256). So I driopped the table, re-created it with the field LOSTYD as datatype int, but still no success...

The second computer works as expected

Can you try removing mapping for M3PRS file and let us know if it works or not