Skip to main content

Hi

Added Reader to extract from Access db source and then insert into destination SQL db (right hand side) and it worked fine:

FMEWanted to add a writer to delete all db records (on the far left) before the reader. However, unable to connect that writer to the reader. Any advice on how can I execute that Delete Writer before the Reader? Thanks.

You can use FeatureReaders / FeatureWriters for this kind of workflow. If you have no features to initiate the proces, you can put a Creator transformer in front of the FeatureReader.

Thanks

 

Created new Feature Writer as below to delete SQL records:server1Able to link that ti AttributeManager and FeatureReader:

server2Ran the FeatureWriter but nothing got deleted in the SQL db. Anything that I missed?

Community Stats

32,049
Posts
121,693
Replies
39,670
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.