SSIS包中CASE与NVARCHAR的恩怨
今天在修改SSIS包时,遇到一个很莫名的情况:
将SQL语句
UPDATE [dbo].[Employee] SET DateOfChange = CASE WHEN (? = ?) THEN ? ELSE GETDATE() END WHERE [SerialNumber] = ?
填入OLE DB Command 组件中,运行后一直报错
“
[
http://www.cyqdata.cn/cnblogs/article-detail-32430