SQL Server Performance Forum – Threads Archive
Global variable in DTS
I have a DTS with a global variable of type string. I want to increase the size of this string variable. How it is possible? What is the default size for a string variable? CanadaDBAI would assume that in the package it is a VB type string which is pretty long itself. Shouldn’t you just update the len of the param in your sp/code and not the DTS package?
The string gets a path and I found when the path is long (85 char) then the value is not initiated into the variable but when I reduce the length of the path to half then it works!
quote:Originally posted by Haywood
I would assume that in the package it is a VB type string which is pretty long itself. Shouldn’t you just update the len of the param in your sp/code and not the DTS package?
CanadaDBA
Interesting…
]]>