SSIS Expressions
-
Hi All,
Just wondered if someone could help, I have an SSIS package with two variables DateVal, and WeekNum.
With dateval it needs to add 7 days to the variable every week when the package is ran and so on and WeekNum needs to add 1 to the previous value up to 4 then reset back to 1 and so on.
If anybody could help it would be much appreciated, I have been trying to do it for a day and half up to now.
-
When packages run, they cannot update themselves, so a wholly package-based solution is not the way ahead.
However, your package can read from and write to a metadata table inside a database. Perhaps this gets you what you want?
Even better (as it's self-contained and infinitely re-runnable) would be to derive your variables from run date. If you are able to do this and can provide the logic, we can help you implement it.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
You might want to use a script to update your variable values rather than use an expression since you are updating every time the package is run.
- karen.ferrara wrote:
You might want to use a script to update your variable values rather than use an expression since you are updating every time the package is run.
If the logic is not too complex, an Expression task may be sufficient. We really need to understand the logic before deciding on the best implementation method, I think.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply