﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:trackback="http://madskills.com/public/xml/rss/module/trackback/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/"><channel><title>博客园-爱拼才会赢-最新评论</title><link>http://www.cnblogs.com/BenjaminYao/CommentsRSS.aspx</link><description>每天起来看一下博客园的博客排行榜，如果第一的位子还不是我的名字，就继续写博客...</description><language>zh-cn</language><pubDate>Thu, 24 May 2012 01:17:39 GMT</pubDate><lastBuildDate>Thu, 24 May 2012 01:17:39 GMT</lastBuildDate><generator>cnblogs</generator><item><title>Re:Google不要走</title><link>http://www.cnblogs.com/BenjaminYao/archive/2012/03/19/1647855.html#2334340</link><dc:creator>benjamin超人</dc:creator><author>benjamin超人</author><pubDate>Mon, 19 Mar 2012 08:45:39 GMT</pubDate><guid>http://www.cnblogs.com/BenjaminYao/archive/2012/03/19/1647855.html#2334340</guid><description><![CDATA[@wzwxwc
美国肯定存在霸权主义，不然也不会出现911事件<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/BenjaminYao/" target="_blank">benjamin超人</a> 2012-03-19 16:45 <a href="http://www.cnblogs.com/BenjaminYao/archive/2012/03/19/1647855.html#2334340#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:Google不要走</title><link>http://www.cnblogs.com/BenjaminYao/archive/2012/03/06/1647855.html#2324070</link><dc:creator>wzwxwc</dc:creator><author>wzwxwc</author><pubDate>Tue, 06 Mar 2012 06:33:01 GMT</pubDate><guid>http://www.cnblogs.com/BenjaminYao/archive/2012/03/06/1647855.html#2324070</guid><description><![CDATA[在中国，企业才开始资本的原始积累
不要太苛求
美国是靠战争和殖民来完成第一步
如果中国的本土企业都完了
你就会看到google也会有它霸道的一面<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/BenjaminYao/" target="_blank">wzwxwc</a> 2012-03-06 14:33 <a href="http://www.cnblogs.com/BenjaminYao/archive/2012/03/06/1647855.html#2324070#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:软件架构设计 温昱著 - 读书笔记</title><link>http://www.cnblogs.com/BenjaminYao/archive/2011/12/12/2268655.html#2267693</link><dc:creator>benjamin超人</dc:creator><author>benjamin超人</author><pubDate>Mon, 12 Dec 2011 01:51:56 GMT</pubDate><guid>http://www.cnblogs.com/BenjaminYao/archive/2011/12/12/2268655.html#2267693</guid><description><![CDATA[@LanceZhang
这人真牛b~<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/BenjaminYao/" target="_blank">benjamin超人</a> 2011-12-12 09:51 <a href="http://www.cnblogs.com/BenjaminYao/archive/2011/12/12/2268655.html#2267693#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:软件架构设计 温昱著 - 读书笔记</title><link>http://www.cnblogs.com/BenjaminYao/archive/2011/12/12/2268655.html#2267623</link><dc:creator>LanceZhang</dc:creator><author>LanceZhang</author><pubDate>Mon, 12 Dec 2011 01:16:53 GMT</pubDate><guid>http://www.cnblogs.com/BenjaminYao/archive/2011/12/12/2268655.html#2267623</guid><description><![CDATA[温昱是个思路很清晰的人，设计过枭龙战斗机的操作系统<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/BenjaminYao/" target="_blank">LanceZhang</a> 2011-12-12 09:16 <a href="http://www.cnblogs.com/BenjaminYao/archive/2011/12/12/2268655.html#2267623#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:从visio数据库脚本生成添加 MS_Description 的sql脚本</title><link>http://www.cnblogs.com/BenjaminYao/archive/2011/07/01/2087827.html#2140626</link><dc:creator>benjamin超人</dc:creator><author>benjamin超人</author><pubDate>Fri, 01 Jul 2011 04:53:25 GMT</pubDate><guid>http://www.cnblogs.com/BenjaminYao/archive/2011/07/01/2087827.html#2140626</guid><description><![CDATA[@huyong
谢谢支持<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/BenjaminYao/" target="_blank">benjamin超人</a> 2011-07-01 12:53 <a href="http://www.cnblogs.com/BenjaminYao/archive/2011/07/01/2087827.html#2140626#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:从visio数据库脚本生成添加 MS_Description 的sql脚本</title><link>http://www.cnblogs.com/BenjaminYao/archive/2011/06/23/2087827.html#2132894</link><dc:creator>huyong</dc:creator><author>huyong</author><pubDate>Thu, 23 Jun 2011 04:58:27 GMT</pubDate><guid>http://www.cnblogs.com/BenjaminYao/archive/2011/06/23/2087827.html#2132894</guid><description><![CDATA[这个看起来不错，支持一下。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/BenjaminYao/" target="_blank">huyong</a> 2011-06-23 12:58 <a href="http://www.cnblogs.com/BenjaminYao/archive/2011/06/23/2087827.html#2132894#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:又到年末</title><link>http://www.cnblogs.com/BenjaminYao/archive/2011/03/10/1921699.html#2043789</link><dc:creator>LanceZhang</dc:creator><author>LanceZhang</author><pubDate>Thu, 10 Mar 2011 12:30:40 GMT</pubDate><guid>http://www.cnblogs.com/BenjaminYao/archive/2011/03/10/1921699.html#2043789</guid><description><![CDATA[~~~~(&gt;_&lt;)~~~~ 上海女婿还这么愁户口，我等硬盘压力感倍增啊！<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/BenjaminYao/" target="_blank">LanceZhang</a> 2011-03-10 20:30 <a href="http://www.cnblogs.com/BenjaminYao/archive/2011/03/10/1921699.html#2043789#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SSIS包中CASE与NVARCHAR的恩怨</title><link>http://www.cnblogs.com/BenjaminYao/archive/2011/03/10/1978577.html#2043562</link><dc:creator>超人哥哥</dc:creator><author>超人哥哥</author><pubDate>Thu, 10 Mar 2011 07:23:42 GMT</pubDate><guid>http://www.cnblogs.com/BenjaminYao/archive/2011/03/10/1978577.html#2043562</guid><description><![CDATA[上面改过顺序的的语句，在运行时报错，再次修改为：
[code=sql]
DELETE FROM dbo.EmployeeRoleSystemPermission WHERE DimEntityTypeId = 1 AND EntityId = ? 

DELETE FROM dbo.EmployeePermissionPriority WHERE EmployeeSerialNumber = ? 

DELETE FROM dbo.EmployeePermissionToOrg WHERE EmployeeSerialNumber = ?

DELETE FROM dbo.EmployeeRoleIndicatorPermission WHERE EntityId = ? AND DimEntityTypeId = 1

[/code]

运行通过...

请注意问号“?”的位置。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/BenjaminYao/" target="_blank">超人哥哥</a> 2011-03-10 15:23 <a href="http://www.cnblogs.com/BenjaminYao/archive/2011/03/10/1978577.html#2043562#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SSIS包中CASE与NVARCHAR的恩怨</title><link>http://www.cnblogs.com/BenjaminYao/archive/2011/03/10/1978577.html#2043535</link><dc:creator>超人哥哥</dc:creator><author>超人哥哥</author><pubDate>Thu, 10 Mar 2011 06:57:37 GMT</pubDate><guid>http://www.cnblogs.com/BenjaminYao/archive/2011/03/10/1978577.html#2043535</guid><description><![CDATA[@巴山游子
根据你的提示，我改成不使用变量输入，如下形式：

DateOfChange = CASE WHEN (? = ?) THEN GETDATE() ELSE GETDATE() END

测试结果仍然报错。

而且今天有新情况，当我在OLE DB Command组件填入下面语句：

[code=sql]
DELETE FROM dbo.EmployeePermissionPriority WHERE EmployeeSerialNumber = ? 

DELETE FROM dbo.EmployeePermissionToOrg WHERE EmployeeSerialNumber = ?

DELETE FROM dbo.EmployeeRoleIndicatorPermission WHERE EntityId = ? AND DimEntityTypeId = 1

DELETE FROM dbo.EmployeeRoleSystemPermission WHERE EntityId = ? AND DimEntityTypeId = 1 

[/code]

结果报错，改成下面的顺序就可以

[code=sql]
DELETE FROM dbo.EmployeeRoleSystemPermission WHERE EntityId = ? AND DimEntityTypeId = 1 

DELETE FROM dbo.EmployeePermissionPriority WHERE EmployeeSerialNumber = ? 

DELETE FROM dbo.EmployeePermissionToOrg WHERE EmployeeSerialNumber = ?

DELETE FROM dbo.EmployeeRoleIndicatorPermission WHERE EntityId = ? AND DimEntityTypeId = 1

[/code]

我估计这是SSIS不能完全判断字符型数据结束位置导致。

<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/BenjaminYao/" target="_blank">超人哥哥</a> 2011-03-10 14:57 <a href="http://www.cnblogs.com/BenjaminYao/archive/2011/03/10/1978577.html#2043535#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item><item><title>Re:SSIS包中CASE与NVARCHAR的恩怨</title><link>http://www.cnblogs.com/BenjaminYao/archive/2011/03/10/1978577.html#2043162</link><dc:creator>巴山游子</dc:creator><author>巴山游子</author><pubDate>Thu, 10 Mar 2011 01:50:37 GMT</pubDate><guid>http://www.cnblogs.com/BenjaminYao/archive/2011/03/10/1978577.html#2043162</guid><description><![CDATA[应该是变量的数据类型与DateOfChange  的数据类型不一致引起。

SQL Server 中的日期类型与SSIS 中的日期类型是不一致的，查一下帮助文件，修改一下就可以了。<br><br><div align=right><a style="text-decoration:none;" href="http://www.cnblogs.com/BenjaminYao/" target="_blank">巴山游子</a> 2011-03-10 09:50 <a href="http://www.cnblogs.com/BenjaminYao/archive/2011/03/10/1978577.html#2043162#Feedback" target="_blank" style="text-decoration:none;">发表评论</a></div>]]></description></item></channel></rss>
