I have an CSV file being dropped to a file location once a day. When SSIS picks it up it's failing due to format issue since it has 3 columns and not delimited with 1 column.
Can someone help me out with this issue?
Sample image below:
-
Could you show an example of the bad data and what you would like it to be like.– harrymcCommented Jul 18, 2019 at 19:57
-
Please check the link int he question– user1064523Commented Jul 18, 2019 at 20:37
-
To what format would you like to transform this CSV?– harrymcCommented Jul 19, 2019 at 8:19
-
To a normal excel output with 30 columns. This daily file get dumped to a file location as a csv via SAP, but with a 3 column instead of the single column. It's difficult to configure to a normal table with headers.– user1064523Commented Jul 19, 2019 at 15:05
-
Could you please add an example.– harrymcCommented Jul 19, 2019 at 15:25
Add a comment
|