Skip to main content
  • EN

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.

sql 1

 

 

sql 

However, I couldn't store and view the past data in the database once the data is update after the automation.

 

Any suggestions?

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.

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​ !

Reply


Community Stats

30,351
Posts
115,343
Replies
38,086
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.