September 3, 2018 at 8:05 am
Hi Experts , i am trying to load from txt file to a table in a database.On flat file file when i preview to sample the data all 12 columns are showing as one column.
Please help how can i fix this.I want the preview as 12 columns not just one long column.
Thanks
T
September 3, 2018 at 8:06 am
Hi there,
Do you have some kind of column delimiter you can use to split into the 12 columns?
September 3, 2018 at 9:02 am
The delimiter is greyed out only row delimiter i can change.
September 3, 2018 at 9:13 am
In your flatfile what is the delimiter?
You should be able to reset columns within the flat file connection manager, and then choose the relevant delimiter.
September 3, 2018 at 9:23 am
tmmutsetse - Monday, September 3, 2018 9:02 AMThe delimiter is greyed out only row delimiter i can change.
In your Flat File connection manager, have you got 'Format' set to 'Delimited'?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply