在 ssis 包中生成先前数据的变量? [英] Variable to generate previous data in ssis Package?

问题描述

我创建了一个变量来检查当前日期如何使用以下表达式获取上一个日期?

I have created a variable which will checks present date how can i get previous date using below expression?

"/Report-"+(DT_WSTR,4)YEAR(GETDATE())
+ RIGHT("0"+(DT_WSTR, 2) MONTH(GETDATE()) ,2)
+ RIGHT("0"+(DT_WSTR, 2) DAY(GETDATE()) ,2)+ ".csv"

Result:
/Report-20140210.csv

如果我需要上一个日期，我如何获得

How can i get if i need previous date

/Report-20140209.csv

推荐答案

您需要将 dateadd 表达式应用到 GetDate 表示您希望减去一天.

You will need to apply the dateadd expression to GetDate indicating that you wish to subtract one day.

"/Report-" + 
(DT_WSTR, 4)  YEAR(dateadd("d", -1, getdate())) 
+ RIGHT("0" + (DT_WSTR, 2)  MONTH(dateadd("d", -1, getdate())), 2) 
+ RIGHT("0" + (DT_WSTR, 2) DAY(dateadd("d", -1, getdate())), 2)
+ ".csv"

产量/Report-20140209.csv

这篇关于在 ssis 包中生成先前数据的变量?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！