Skip to main content

Hi Guys,

 

New to FME but really enjoying the journey to date. Today I hit my first confusing issue which although I have resolved I am pretty sure they must be a better way.

 

I had:

  • Created an MSSQL table
  • Created an FME reader which detected the schema including attribute types and so forth.
  • Did some processing and wrote to a file geodatabase.

 

But:

  • I then made some minor changes to the underlying MSSQL table i.e. changed text to decimal etc.
  • However the reader would not detect these changes. I had to delete and recreate the reader for then changed to be detected.

 

Is there some easier method which I am missing to get the reader to detect changes to the table schema in the database?

 

Apologies in advance if the solution is simple but I am missing it!

 

Thanks,

Barry.

You can use the Update reader feature types functionality:

https://desktopmanualbasic.safe.com/DesktopBasic4Components/4.09.UpdatingReaderFeatureTypes.html

It does not automatically detect changes to the underlying tables, but it's easier than recreating the reader.


You can use the Update reader feature types functionality:

https://desktopmanualbasic.safe.com/DesktopBasic4Components/4.09.UpdatingReaderFeatureTypes.html

It does not automatically detect changes to the underlying tables, but it's easier than recreating the reader.

Super David, many thanks for the help, it is very much appreciated!