Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bonjour j'ai un premier projet à faire dans talend et je galére , pour intégrer une table dans une autre , sachant que la table à un index auto-incremente.
Je n'arrive à rien insérer dans ma table pourtant dans le log c'est pas si mal et le traitement termine par : [Code sortie=0]
Bref si quelqu'un peux m'aider ce serait cool
MErci
That is interesting!
This looks fine. Could you please try to do a select from same table using tDBInput after data insert (using same DB connection)? If the data is present in the table, it will show in that query.
If that is also working fine, I do not have any clue right now.
Lets check the opinion of @xdshi also.
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
Hello,
This is an international forum and English is the language we use. Posting in English will allow you to get more visibility and more help. Thanks for your understanding!
Best regards
Sabrina
Hi,
Based on the Google Translate version, I am giving the comment from my end. Could you please check whether you have selected Die on Error Option in your tDBOutput component? Please also make sure that you are commiting the transactions. You can do it either by selecting Auto Commit option in the Advanced Section of tDBConnection component or you can use tDBCommit component (connect it with a On Component Ok with tDBOutput).
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
Could you please advise whether you were able to resolve the issue after making the changes suggested by me? If the issue has been fixed, could you please mark this topic as resolved? It will help other Talend community members during their reference.
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
Hello and thank's a lot
I try like your helping but no insert in my table sql server. Purhaps nothing is red in my disigner
When i make a insert sql it's ok but nothing with talend.
I give you the shema on my table sql server
USE [DWACIS]
GO
/****** Object: Table [dbo].[SBASE_EIG_F_ANHISTSAL] Script Date: 07/01/2020 15:36:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SBASE_EIG_F_ANHISTSAL](
[BL_HISTO_ID] [int] IDENTITY(1,1) NOT NULL,
[BL_HISTO_ANNEE] [int] NOT NULL,
[BL_HISTO_MOIS] [int] NOT NULL,
[BL_HISTO_DATE] [datetime2](7) NOT NULL,
[BL_HISTO_CTRID] [int] NOT NULL,
[BL_HISTO_PERID] [int] NOT NULL,
[BL_HISTO_ETAB] [nvarchar](50) NOT NULL,
[BL_HISTO_SECT] [int] NOT NULL,
[BL_HISTO_LIBSECT] [nvarchar](50) NOT NULL,
[BL_HISTO_PERMAT] [int] NOT NULL,
[BL_HISTO_PERNOM] [nvarchar](50) NOT NULL,
[BL_HISTO_PERPRENOM] [nvarchar](50) NOT NULL,
[BRUT] [float] NULL,
[B_PXHEURE] [float] NULL,
[COEFREF] [float] NULL,
[COEFCONV] [float] NULL,
[COEFANC] [int] NULL,
[NB_HEURESTPAYE] [float] NULL,
[B_COUTNET] [float] NULL,
[NB_HEURESASS] [float] NULL,
[CHARGEENPLUS] [nvarchar](50) NULL,
[CATMODIF] [int] NULL,
[NB_JRSTRAV] [int] NULL,
PRIMARY KEY CLUSTERED
(
[BL_HISTO_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
Hi,
Could you please share the component screenshot of the tDBOutput component (Please mask the confidential part before sharing)? Have you selected Die on error option in it?
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
Hello,
Yes i have selected stop with error
What do you think about my shema ?
That is interesting!
This looks fine. Could you please try to do a select from same table using tDBInput after data insert (using same DB connection)? If the data is present in the table, it will show in that query.
If that is also working fine, I do not have any clue right now.
Lets check the opinion of @xdshi also.
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
Ok thank's i try and i tell you
+++