Truncate table and insert data from a view

Highlighted
Six Stars

Truncate table and insert data from a view

First i recover my ID_MAX and save it in a context (Done), after i want to truncate my table but i get an error. I don't understand why he didn't found my table. If someone can explain how it's work. 

 

Thank you.


Accepted Solutions
Six Stars

Re: Truncate table and insert data from a view

So it's was just a basic SQL mistake… i wrote server_myTable and it's was server.myTable…

I close the subject.

View solution in original post


All Replies
Six Stars

Re: Truncate table and insert data from a view

So it's was just a basic SQL mistake… i wrote server_myTable and it's was server.myTable…

I close the subject.

View solution in original post

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now