Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2015-06-09 04:02 AM

Pull fixed field to SQL server 2008 table

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.
Labels (2)
Labels
165 Views
0 Likes
1 Reply
Anonymous
Not applicable
‎2015-06-09 07:12 AM
Author

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
165 Views
0 Likes