Hello,
Does anyone know the maximum length of global variable of type "String" in DTS.

I have a string (greater than 180) that works its way out through a stored procedure hierarchy, back out into DTS and then inserted into a table. The string ends up length 180 and the only way I can envisage that it is getting truncated is when it comes into my DTS GV.

Hence, I'm hoping that the answer to my question (above) is 180 because that would expalin the strange behaviour that I am seeing.

Any help much appreciated.
Jamie Thomson

Try this


Function Main()

DTSGlobalVariables("MyVar180").Value = "IamOver 180 chars long
x x
x x 181"

Msgbox len(DTSGlobalVariables("MyVar180").Value)


Main = DTSTaskExecResult_Success
End Function


I get

183



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

string ends up length 180 and the only way I can envisage that it is getting
truncated is when it comes into my DTS GV.

Thanks Allan,
That helped me to prove the problem wasn't what I was hoping it was.

Regards
Jamie

"Allan Mitchell" wrote:

FYI: In fact using an adapted method I've been able to build a string >4MB so far. I've stopped now!!!

"Jamie" wrote: