Environment: SQL 2005 EE RTM

I am trying to provide a dynamic XMLA string to an Analysis Services
processing task using a package-level variable. My XMLA string is
about 5400 characters long. I am able to put the value into the
variable in a Script task, but it goes down in the AS processing task
within an expression that is using the variable for the
ProcessingCommands value. The message states that there is a 4000
character limit within the expression. If I paste the value into the
property, it runs fine.

Anybody seen this?

TIA
Randy

Expressions can be limited to 4000 characters, and this is what you are
seeing. Bit of a pain actually and I cannot see a simple way round it right
now.

"In some cases, Integration Services imposes a 4000-character limit on the
length of expressions. If the evaluation result of an expression has the
Integration Services data type DT_WSTR or DT_STR, the expression will be
truncated at 4000 characters. If the result type of a sub-expression is
DT_STR or DT_WSTR, that sub-expression will likewise be truncated to 4000
characters, regardless of the overall expression result type."


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com


"Randy Martin" <randy.martin (AT) ds-iq (DOT) com> wrote

Darren,

I was afraid that this would be the case. I will look at other
options, including stuffing the value into the AS task property via
code somewhere in the package.

Thanks for the quick response.
Randy

You cannot set properties from within a package, your only option is
expressions. You cannot access the object model in this way in SSIS.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com

"Randy Martin" <randy.martin (AT) ds-iq (DOT) com> wrote

OK, good to know where the brick wall is before heading down the
dead-end...