Hi all,
I would like store the historical data in FME Server to MS SQL Server database. I have successfully store the data from FME Desktop to the SQL Server. Then I have publish the workspace to FME server to do the automation which will update the data daily at 9.00 AM.
However, I couldn't store and view the past data in the database once the data is update after the automation.
Any suggestions?
Best answer by redgeographics
Check how your writer feature type is set up, if you want to add data it should be set to INSERT and not to drop or truncate an existing table.
+49Check how your writer feature type is set up, if you want to add data it should be set to INSERT and not to drop or truncate an existing table.
Check how your writer feature type is set up, if you want to add data it should be set to INSERT and not to drop or truncate an existing table.
Great, it works now. Thank you @Hans van der Maarel !
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
