March 7, 2011 at 9:24 am
how should i cast package name variable and getdate.....can anyone give mee the exact expressions ...new to ssis
March 7, 2011 at 9:33 am
quillis131 (3/7/2011)
how should i cast package name variable and getdate.....can anyone give mee the exact expressions ...new to ssis
Please take a little more care with your question.
What do you mean by 'package name variable'?
What do you want to cast it from/to?
You can't cast getdate - it's a function. What do you mean?
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
March 7, 2011 at 9:59 am
i need a expressions with my package name (using system variable) and today's date..
ex ABC110307 this should be my outcome
where ABC - package name
110307 is today's date
March 7, 2011 at 10:15 am
Try this:
@[System::PackageName] + RIGHT((DT_STR,4,1252)YEAR(GETDATE()),2) + RIGHT("0" + (DT_STR,2,1252)MONTH(GETDATE()),2) + RIGHT("0" + (DT_STR,2,1252)DAY(GETDATE()),2)
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
March 7, 2011 at 10:21 am
thank you ....
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply