i****a 发帖数: 36252 | 1 same thing worked perfectly in 2000 DTS doesn't work in SSIS
SQL 2000 DTS imports CVS file like this:
file: hello, """this"", is double quoted"
database: [hello], ["this", is double quoted]
SQL 2005 and 2008:
file: hello, """this"", is double quoted"
database: [hello], ["this"], [is double quoted]
it broke the field into two columns...
WTH.... |
B*****g 发帖数: 34098 | 2 你早就该弃暗投明
【在 i****a 的大作中提到】 : same thing worked perfectly in 2000 DTS doesn't work in SSIS : SQL 2000 DTS imports CVS file like this: : file: hello, """this"", is double quoted" : database: [hello], ["this", is double quoted] : SQL 2005 and 2008: : file: hello, """this"", is double quoted" : database: [hello], ["this"], [is double quoted] : it broke the field into two columns... : WTH....
|
i****a 发帖数: 36252 | 3 confirmed it's an issue of M$, I am not smoking funny pipes...
https://connect.microsoft.com/SQLServer/feedback/details/312164/flat-file-
parser-cannot-import-files-with-embedded-text-qualifiers#details |
g***l 发帖数: 18555 | 4 尽量不用DOUBLE QUOTE了,一般都用PIPE DELIMITED,SSIS是重写的完全放弃了DTS,
DTS已经被彻底淘汰了。今天2005 EXPORT EXCEL,长STRING死活就是EXPORT不出来,最
后用了QUERY RESULT SAVE AS TEXT,然后再用EXCEL打开,是有些烂字符。 |
i****a 发帖数: 36252 | 5 vendor file, 沒有辦法啊
excel imports it correctly...
I've tested with LogParser, it reads it correctly too. gonna use LogParser
to convert it into tab delimited or something.
【在 g***l 的大作中提到】 : 尽量不用DOUBLE QUOTE了,一般都用PIPE DELIMITED,SSIS是重写的完全放弃了DTS, : DTS已经被彻底淘汰了。今天2005 EXPORT EXCEL,长STRING死活就是EXPORT不出来,最 : 后用了QUERY RESULT SAVE AS TEXT,然后再用EXCEL打开,是有些烂字符。
|
g***l 发帖数: 18555 | 6 全部倒入一个FIELD,去掉DOUBLE QUOTE再PARSE,搞成个SSIS PACKAGE好了
【在 i****a 的大作中提到】 : vendor file, 沒有辦法啊 : excel imports it correctly... : I've tested with LogParser, it reads it correctly too. gonna use LogParser : to convert it into tab delimited or something.
|
L*******r 发帖数: 8961 | 7 这个确实有点恶心。不过这不是SSIS的错,是EXCEL的DRIVER把
长字符TRUNCATE了。都是MS的东西,互相不匹配。
【在 g***l 的大作中提到】 : 尽量不用DOUBLE QUOTE了,一般都用PIPE DELIMITED,SSIS是重写的完全放弃了DTS, : DTS已经被彻底淘汰了。今天2005 EXPORT EXCEL,长STRING死活就是EXPORT不出来,最 : 后用了QUERY RESULT SAVE AS TEXT,然后再用EXCEL打开,是有些烂字符。
|
i****a 发帖数: 36252 | 8 2008 SSRS, exporting a report with matrix to CSV doesn't work anymore....
WTF.... |
m******y 发帖数: 588 | 9 我前几天在新的server装sql server 2005, 那个server上面有24个processors,装了半
天一直出错,也搞不懂为什么,后来看kb才知道processor必须是2的power数才行。
microsoft真是没道理呀!
http://support.microsoft.com/kb/954835/en-us |
B*****g 发帖数: 34098 | 10 弃暗投明吧,oracle group欢迎你,哈哈。
【在 m******y 的大作中提到】 : 我前几天在新的server装sql server 2005, 那个server上面有24个processors,装了半 : 天一直出错,也搞不懂为什么,后来看kb才知道processor必须是2的power数才行。 : microsoft真是没道理呀! : http://support.microsoft.com/kb/954835/en-us
|