SSIS <none> text qualifier results in text file containing "_x003C_none_x003E"
来源:互联网 发布:蛋糕店游戏不要网络的 编辑:程序博客网 时间:2024/04/28 02:12
There is a bug in SSIS when exporting data from SQL to a comma delimited text file where you specified no text qualifier.
This bug apparently only occurs when you develop the SSIS on a x64 win7 PC and copy the .dtsx file (windows explorer copy/paste) to network path of a x86 SQL server and schedule the job to run from SQL Agent on the same x86 SQL server.
When the SSIS runs, the text file is written out containing text qualifier = "“_x003C_none_x003E".
If you look at " _x003C_none_x003E", it actually means <none>. x003C = "<" and x003E = ">".
If you go into the SSIS package, double-click in the connection manager section to open the flat file connection manager editor and try to clear the text qualifier removing the <none>, the <none> value get added back in.
The only work-around is to NOT open the flat file connection manager editor, but instead make the change using the property window and clear out any value in the TextQualifier field.
Other similar problems occur when you actually want to put a real value in the text qualifier. For explain if you select the double-quote as the text qualifier and copy to a x86 server and run, you end up with a text file containing the value " _x0022" around each field instead of a double quote.
In my mind this is a serious bug, I did some research and other people have been having this same issue.
FYI, the SQL server is currently SQL2008 with SP2. I will try to get it updated to SP3/4 this weekend to see that will help.
FYI2, when I am developing the SSIS using VS2008 and my local test/run is done through visual studio on my Dev PC (x64). Everything works fine this way. I do not have a instance of SQL on my machine so I did not test it running from SQL Agent on my PC.
This is a bug but there is no bug report anywhere . It was resolved with sql server 2008 sp1 cummulative update 6 (10.00.2757) or higher
- SSIS <none> text qualifier results in text file containing "_x003C_none_x003E"
- Drag and Drop text containing file in textbox.
- Save MySQL query results into a text or CSV file
- Save MySQL query results into a text or CSV file
- read UTF-8 text file in C++
- Unexpected text found in layout file: """
- Unexpected text found in layout file: """
- Unexpected text found in layout file: """
- Unexpected text found in layout file: """
- Unexpected text found in layout file: """
- Unexpected text found in layout file
- Warning: Unexpected text found in layout file....
- unexpected text found in layout file
- -webkit-text-size-adjust: none;
- How do I cover the “no results” text in UISearchDisplayController's searchResultTableView?
- How to read Json file or text file in Spark
- How to remove ^M in a uploaded text file?
- How to Open a Text File in VB .NET
- 使用JSON传递接收集合,对象map for json,json for java
- SharedPreferences 的用法
- 杭州最新公交线路一览(71-80)
- Xcode 4.1 bug: Text Field 引起 EXC_BAD_ACCESS 错误的解决
- 杭州最新公交线路一览(81-90)
- SSIS <none> text qualifier results in text file containing "_x003C_none_x003E"
- 《系统程序员成长计划》阅读笔记--温故之用
- 处理请求参数乱码问题
- 用JavaScript在框架中打开网页
- DIV嵌套时外层无法自适应高度三种解决方案
- 浅谈HTML中NAME和ID的区别
- ligerui中的tree的异步动态加载数据库例子
- javascript 全局属性和函数
- 某人的经验教训~~