I'm dealing with MSSQLDBInput Component connected too a MSSQLDBOutputBulk component. My output is only returning the first column in my output. Not the second column (CodeDescription) which I have in my DBOutputBulk Schema.
Can anyone see any issues that would be causing the outputbulk component to not include both fields I have listed in SS?
My MSSQLDBInput has the following query
"DECLARE @ApprovedClients AS TABLE (
INSERT INTO @ApprovedClients VALUES
--Initial Go Live
--TSA South --DEV ONLY: Added 2/28/19
'000' + ClientID + [NewCode] AS CodeKey
CROSS APPLY @ApprovedClients
WHERE [YLM_InputFile] = 'Donor'
AND [FieldName] = 'Type'
ORDER BY 1,2"
In your previous post, you have mentioned that you are running insert statements through tMSSQLDBInput. You are running lot of DB statements in a single tDBInput. Could you please add one select statement only per tDBInput and then join the tables using a tMap?
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 :-)
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema