Create an array of strings in SSIS SQL Server If you need to use an array of strings in SSIS it is a little difficult to create it as a variable in the package. It takes defining the package variable as a system.object and calling a script task, either VB or C# (example is VB.NET). In my example I set System as the system.object. The sample Main procedure sets the first element of the string array to the package name. Public Sub Main () Dim arr As String () ReDim arr(0) arr Value Dts.Variables( " User ::Categories" ).Value = arr Dts.TaskResult = ScriptResults. Success End Sub Create an array of strings in SSIS ( 3 Views ) View Allen Stoner's FAQs Create New Account keywords: SSIS, Script
Array.append C++ / VB Is there anything like an append function in VBScript? I need to Is there a function to do this or can I loop through each on and array.append(data) to a third array? Array A 1, 2, 3, 4 Array B 5, 6, 7, 8 I need one array containing 1, 2, 3, 4, 5, 6, 7, 8 THanks. VBScript Discussions ASP.NET (1 VB (1) JoinVBArrays (1) ClArrayUBound (1) MArr.AddArray (1) CMergedArray (1) Array.append (1) VBScript (1) There is no append function or method, but I can think wsh / No. That's one way. It's pretty simple . . . Dim A, B, C() A = Array(1, 2, 3, 4) B = Array(5, 6, 7, 8) ReDim C(Ubound(A) + UBound
Can't read array values .NET Framework Hello! I have a (crazy) problem: I want to read some information from an LDAP. I have an array: dhcpHWAddress = objExp.GetEx("dhcpHWAddress") type 8209 (array of byte) This array has only one value. An second array. This second array has always exactly the same amount of values like the LDAP-attribute. (15 chars = > 15 of working with byte arrays. The VarType function does return 8209, which indicates: vbArray 8192 Array vbByte 17 Byte subtype, but you cannot use VBScript's array syntax to access individual elements of the array. I am really surprised at this statement