https://community.qlik.com/t5/Talend-Studio/Pull-fixed-field-to-SQL-server-2008-table/m-p/2353275#M119508 I am new to Talend Open Studio Data Integration and downloaded the Talend Open Studio Data Integration.&nbsp; <BR /> <FONT color="#222222"><FONT size="2"><FONT face="'Helvetica Neue', Helvetica, Arial, sans-serif">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.</FONT></FONT></FONT> Tue, 09 Jun 2015 08:02:45 GMT Anonymous 2015-06-09T08:02:45Z https://community.qlik.com/t5/Talend-Studio/Pull-fixed-field-to-SQL-server-2008-table/m-p/2353275#M119508 I am new to Talend Open Studio Data Integration and downloaded the Talend Open Studio Data Integration.&nbsp; <BR /> <FONT color="#222222"><FONT size="2"><FONT face="'Helvetica Neue', Helvetica, Arial, sans-serif">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.</FONT></FONT></FONT> Tue, 09 Jun 2015 08:02:45 GMT https://community.qlik.com/t5/Talend-Studio/Pull-fixed-field-to-SQL-server-2008-table/m-p/2353275#M119508 Anonymous 2015-06-09T08:02:45Z https://community.qlik.com/t5/Talend-Studio/Pull-fixed-field-to-SQL-server-2008-table/m-p/2353276#M119509 Hi,<BR />Have you already checked component <A href="https://help.talend.com/search/all?query=tFileInputPositional&amp;content-lang=en" target="_blank" rel="nofollow noopener noreferrer">TalendHelpCenter:tFileInputPositional</A> which can reads a given file row by row and extracts fields based on a pattern.<BR />The workflow should be:tFileInputPositional--&gt;tMSSQLOutput.<BR />Best regards<BR />Sabrina Tue, 09 Jun 2015 11:12:30 GMT https://community.qlik.com/t5/Talend-Studio/Pull-fixed-field-to-SQL-server-2008-table/m-p/2353276#M119509 Anonymous 2015-06-09T11:12:30Z