问题描述
我正在使用 ADO.NET 源将数据从 ODBC 服务器传送到我的 SQL.我使用导入和导出向导来创建我的数据流任务.
I am using a ADO.NET source to bring data from an ODBC server to the my SQL. I used the import and export wizard to create my data flow task.
我需要添加具有字段 GPMTADDT>(昨天日期)的新记录例如,如果今天 20121002 以下查询完美运行:
I need to append new records that have field GPMTADDT>(yesterday date) for example if today 20121002 the following query works perfectly:
SELECT PARTICIP.*
FROM PARTICIP
WHERE GPMTADDT > 20121001
我试过了:
SELECT PARTICIP.*
FROM PARTICIP
WHERE GPMTADDT > Format(now(),"yyyymmdd")
但它不起作用,服务器将格式"视为一列.我尝试创建一个变量 @date
But it will not work, the server treats "format" as a column.
I tried creating a variable @date
SELECT PARTICIP.*
FROM PARTICIP
WHERE GPMTADDT > @date
服务器再次拒绝了@".
again the server rejected the "@".
Also tried:
SELECT PARTICIP.*
FROM PARTICIP
WHERE GPMTADDT > (SELECT MAX PARTICIP.GPMTADDT FROM PARTICIP)
我确定我遗漏了一些简单的东西,我们将不胜感激.
I am sure I am missing something simple, help will be greatly appreciated.
谢谢!
推荐答案
您是否尝试过:
SELECT PARTICIP.*
FROM PARTICIP
WHERE GPMTADDT > DATEADD(dd, -1, GETDATE())
这篇关于带参数的 SSIS 流 ADO 源任务的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
更多推荐
[db:关键词]
发布评论