Gets strange errors when trying to load table

[Anonymous]

Hi!

When running the job without a target table and only us tlogrows as targets, the job works fine (as seen below)

But when I connect a target table I get some strange error, which seems to point at the extract from the source table (see below) What am I doing wrong? I use the same connection in source as in target. Anyone?

[Anonymous]

Hi
Can you upload a screenshot of the basic settings of tDBInput and tDBOutput?

Regards
Shong

[Anonymous]

Sorry for the late replay. Here are the source and target connections

DBInput Basic

DBOutput

What have I done wrong?

Regards

Patrik

[Anonymous]

Anyone? Any idea?

[Anonymous]

Hi PatrikLager
if you are using the same connection, why don't you select the same DB metadata connection in Repository list? I see one is localSQLServer, and another one is localMSServer. For testing, try to select the same DB metadata connection?

Regards
Shong

[Anonymous]

Hi,

     Its a good idea to have the connections ready first and then use those connection components in the subsequent DB components like Input and Output.

     This will make sure that your connection to DB is fine at an earlier stage.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved