i have a strange problem, i am trying to create a import package to import data from a CSV file.
When I create a flat file source and take a look at the preview I see that the fields are mixed up. Some fields are ok, but quet a few arent.
When I open the CSV in excel or a other program it looks good, all rows are ok.
When i import the CSV in access it is also ok. So I'm a bit confused where the problem lies.
Does anyone have a idea?
all the settings are standard.
The strangest thing is that when i replace al the semicolons to for instance tab's the problem keeps.
View Complete Post