I am currently encountering an issue while attempting to execute an ETL job aimed at migrating data from a SQL Server database to a Postgres DB. The process consistently fails due to an error whose resolution eludes me. Should I anticipate the existence of the target table and expect to write information onto it, or is there another approach I should consider to address this recurring error?
The script is pretty simple, as it is just a select statement that select the appropriate columns from the source to insert them in the target.
I am currently encountering an issue while attempting to execute an ETL job aimed at migrating data from a SQL Server database to a Postgres DB. The process consistently fails due to an error whose resolution eludes me. Should I anticipate the existence of the target table and expect to write information onto it, or is there another approach I should consider to address this recurring error?
The script is pretty simple, as it is just a select statement that select the appropriate columns from the source to insert them in the target.