Skip to main content
Best Answer

How to store data in MS SQL Server database every time automation process is successfully?

  • May 3, 2021
  • 2 replies
  • 48 views
A

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?

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

redgeographics
Celebrity
Forum|alt.badge.img+62
  • redgeographicsCelebrity
  • Celebrity
  • Best Answer
  • May 3, 2021

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.

FME rocks! \m/
A
  • aafirah
  • Author
  • May 5, 2021

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

Community Stats

32,181
Posts
122,172
Replies
39,855
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.