Hi,

I want to know if there is any way by which I can use a global variable
having data type other than string which can let me store more than 4000
characters ie more than allowed in a string.

It seems like string data type has length limitation (limited to 4000
chars). I want to use a variable to pass values (for eg. XMLA) between 2
tasks which can go over the limit.

Thanks

Global variables are not limited to 4000 characters. As a double check I
stuffed 10,000,000 characters and that worked fine.

T-SQL types have limites similar to this, such as nvarchar and nchar have a
limit of 4000. ntext on the other hand has a capacity of 1,073,741,823.


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

"Sourabh" <Sourabh (AT) discussions (DOT) microsoft.com> wrote

Darren,

Thanks for the reply.

I meant to ask about variables which can be defined in a DTS package i.e.
variables on the package/task or container level.

Thanks,
Sourabh

"Darren Green" wrote:

I really don't understand what you are asking about. A global variable
is a variable created at the package level, and they can handle large
values. There is no such thing as containers in DTS.


If you are talking about SSIS, then I haven't checked what the capacity
is, but then they can be created on a container. If you mean SSIS, then
please say so, and preferably use th 2005 newsgroups.

Darren


Sourabh wrote:

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

Yes, I am talking about SSIS.

"Darren Green" wrote:

I tried a SSIS string variable with 20000 characters and this was persisted
between two script tasks just fine.

I strongly suspect you are working through SQL somewhere and getting chopped
at the nvarchar limit. This does not look like an SSIS issue at all.


"Sourabh" <Sourabh (AT) discussions (DOT) microsoft.com> wrote