如何将定界的文本文件Thorn(þ)加载到sql-server 2012 [英] how to load Text file Thorn(þ) delimited into sql-server 2012

问题描述

我有类似这样的文本文件

I have text file something like this

col1þcol2þcol3þcol4
aaaþbbbþcccþddd
xxxþyyyþzzzþabs
123þtyehþyetþethrr

我尝试使用ssis包

i tried loading into sql-server using ssis package after following steps from here but i couldn't find solution,could somebody guide me in my execution

包失败:

这是程序执行的快照

[Flat File Source [8]] Error: Data conversion failed. The data conversion for column:<column namesss> 

它的输出是这样的

我尝试进行的更改:像这样

the changes i tried making: like this

推荐答案

将thorn更改为您的列分隔符，而不是行分隔符.然后将行定界符更改为换行符(大概是换行符).

Change thorn to be your column delimiter, not your Row delimiter. Then change your row delimiter to be line break (presumably).

要执行更多操作，我们需要查看表定义和包定义的其余部分，尤其是列分配.

To do any more we'll need to see your table definitions and the rest of your package definition, particularly the column assignments.

这篇关于如何将定界的文本文件Thorn(þ)加载到sql-server 2012的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！