Upgraded to FME 2023. When writing to SQL server database, Bulk Insert = 'Yes' results in features dropping and not writing to DB (even though the correct amount of features are listed in the Total Features Written message). If I set Bulk Insert = 'No', the correct number of records write to the DB but one of the nvarchar attributes is empty in the database. Everything looks correct in the final inspector prior to writing. This is using workbenches originally created on 2022.1.2.0, Build 22627. New version of FME is 2023.0.0.3, Build 23319. I reran workbenches on 2022 and it's working correctly
Page 1 / 1
Hi @mcannalea12 I tried reproducing this issue in FME 2023.0.0.3 but haven't had any success so far.
Would you be able to share some more information about the data you are writing to your database? How many features are you writing to your SQL Server? What data types are contained within your schema? Are you writing to an existing table or creating a new one? If you're able to share some source data and a workspace, this would be very helpful for resolving the issue.