I am new to Talend Open Studio Data Integration and downloaded the Talend Open Studio Data Integration. I want to pull Flat fixed field text file to SQL server table (SQL server 2008). This has to be done every day. Table contains more than 300 columns. While pulling the text file each and every time or every day I cannot split 300 columns manually, based on column length. In SQL server 2000, we have DTS package. Is there any similar option in Talend Open Studio Data Integration software to pull fixed field text file and also to save that job as like SQL DTS package.
Hi, Have you already checked component TalendHelpCenter:tFileInputPositional which can reads a given file row by row and extracts fields based on a pattern. The workflow should be:tFileInputPositional-->tMSSQLOutput. Best regards Sabrina
-- Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.