我在SSIS中添加了一个变量,并且尝试在表达式查询中添加tha变量。但是它说Expression cannot be evaluated
下面是我的表达式查询。如果您知道我在哪里犯错,请提供帮助。
SQL查询
SELECT c.CustomerName, o.OrderID from Customers c
INNER JOIN Orders o ON c.CustomerID=o.CustomerID
Inner Join OrderDetails od ON od.OrderId = o.OrderID
Inner Join Products p on p.ProductID = od.ProductID
where ISNULL(c.IsResult,0) = 0 and o.CompanyID = @CompanyID
表达格式
"SELECT c.CustomerName, o.OrderID from Customers c
INNER JOIN Orders o ON c.CustomerID=o.CustomerID
Inner Join OrderDetails od ON od.OrderId = o.OrderID
Inner Join Products p on p.ProductID = od.ProductID
where ISNULL(c.IsResult,0) = 0 and o.CompanyID ="+ @[User::intCompanyID]
让我知道我是否做对了。
我发现将数字值强制转换为String或Unicode是可行的。所以也许尝试
ISNULL(c.IsResult,0) = 0 and o.CompanyID ="+ (DT_WSTR,20) @[User::intCompanyID]
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句