Hi FME Community
I have encountered an issue that I cannot find the solution for.
I have a Reader -> Writer setup. Reading from a MSSQL db and writing to a Postgres.
When reading the table and making a preview, everything looks as it should be.
Then I run the transport and looking at the preview of the writer after a successfull termination of the task.
And this is what I see
Even though I've made a Scheme called 'dbo'. and the DB-connection setup is successfully connected. The table isn't to be found in the PG-db.
I've encountered this a couple of times, especially when writing to databases, however I cannot find any consistency in when it will or won't populate the tables.
I've tried to make a transformer inbetween, sometimes it works, sometimes it won't.
Sincerely
