Importing CSV, transforming field type, and outputting to MS SQL Server

[Anonymous]

Hi -- I am new to Talend and ETL.

I have a csv that I need to bring into Talend.  I need to review the types for each of the fields, then I need to change one of them.  Then I need to output to a local MS SQL Server DB.

I've been poking around YouTube videos and Google, but haven't really found what I'm looking for.

Any help would be greatly appreciated.

[manodwhb]

@CD9999,create a metadata fro csv in repository of Talend and create a job and use that metadata as tFileinputDelimited and connect to tMSsqlOutput to tFileinputDelimited .

[Anonymous]

I only see tMSSqlConnection – not tMSSqlOuput. Is it the same thing?

[iamabhishek]

No, they are different.
Goto Palette -> Databases -> MS Sql Server
You would then find all the components related to MS Sql Server.

[Anonymous]

Ah ok – I see “tDBOutput(Microsoft SQL Server)” – I’m assuming that’s it.

How would I pull the schema from my MSSQL Server DB so that I can compare incoming datasets to the schema I currently have (and make adjustments to the DB schema as necessary)?

[Anonymous]

Hi,

     Please refer the link below to understand how we can retrieve the all table schema from a DB using Talend Metadata.

https://help.talend.com/reader/hULYZJz6QBG0R8nvFrppxQ/EntMthts4SKiXVAFTv9Ypw

    If the details have helped you, could you please mark the topic as resolved?

Warm Regards,

Nikhil Thampi