March 16, 2009 at 10:34 am
I am trying to build the filename dynamically using expression. Works fine while evaluating expression. But erroring out while executing the pacakte.
Package validation error:
Connection string cannot be written to the property. The expression was evaluated but cannot set the property.
Here's my connection string:
@[User::FileName] + (DT_STR,4,1252) YEAR(Dateadd("dd", -1, getdate())) + RIGHT((DT_STR,4,1252) (100 + MONTH(Dateadd("dd", -1, (GETDATE())))), 2) + RIGHT((DT_STR,4,1252)(100 + DAY(Dateadd("dd", 0, GETDATE()))),2) + ".txt"
Any idea?
March 16, 2009 at 11:15 am
What does your User::FileName variable contain at runtime? You are trying to use the initial value and append a datetime stamp to it, but if the variable is initially NULL, I'm not sure that will work. Can you attach screenshots of the relevant parts of the package?
Regards
Lempster
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply