I'm very new to Talend (Talend Open Studio for Data Integration 7.0.1). Hoping to use it to simply move data from a delimited text file to a SQL Server database.
My issue is when creating the Metadata for the "File delimited", I'm wanting Talend to NOT determine the data type (Step 4 of 4 - Define the Schema in the wizard). I'm wanting everything to be "Strings".
Instead it appears to be determining what the type should be - and is causing me issues later when I map the data. I understand I can go one-by-one and change each one on that screen (Step 4 of 4), but I'm talking very many files, with hundreds of fields in each.
Is there a setting or something I can set to make all the fields in my File delimited schema to be defined as "Strings" ?
Thanks in advance!
Solved! Go to Solution.
Hi TRF -
Using the file with just the headers (and then putting the data back afterwards) - worked. Not the perfect solution - but it does work! Thank you!!
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