Hi everyone, take it easy on my here, this is my first go at any sort of "ETL" tool. In a nutshell I would like to take a single flat file that contains groups of records and create a shell for a baseline SQL Server environment, tables based on the field name and lenghts and continue to populate the tables with daily files. For startes I would like to know where to start in the studio, I have my flat text file sitting here...how can I use Talend to set the field lenght positions to populate my SQL DB? Im sure im wording this poorly, ask me questions and I can respond. Thanks! J
Please find my screen shot i am getting error as Exception in component tMSSqlInput_1 java.sql.SQLException: An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
Please revert me to mail : shivi.bhatt@igate.com please help on this Thanks Shivi Bhatt
