Select the "Auto-Format as you Type" tab. In MS Word, first turn off the option to replace quotes with special quotes: I also tried using Excel, but it had a similar outcome.Īnother (messy) approach, along the lines of using a regular expression, would be to open the file in MS Word, and remove the extra carriage returns first. On the preview page, the sample data appears as you described - broken with regards to data enclosed in quotes, but split over several lines. The format is set to "Delimited", the Text Qualifier to "", the Header Row Delimiter to "", and Header Rows To skip to "0" (you'd set this to 1 if you had a header row).It automatically detected the file's locale and code page.In data source, I selected "Flat File Source".I ran the SSIS import wizard by selecting my database in Management Studio, then choosing import. "19760102","","1fdddddddddddddddddddddddddddddddddddddddddddddddddddddddddddddd I just tried a simple example along the lines of the data you just gave me, with the following input:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |