excel sheets exported to CSV can be inported to SSIS, but if a fields already contains comma, the package will read the csv structure wrong. In the text delimter field for the flat file manager, put in a double quotes ("), and it will work correctly.
Ingen kommentarer:
Send en kommentar