Viewing 6 posts - 1 through 6 (of 6 total)
Thanks for this.
Adding just "write" permissions for the distributor agent on the folder mentioned in the error (on the distribution server) fixed this problem for me.
Stu
January 20, 2020 at 3:46 pm
Have you tried debugging the size of the array?
What is the data type of this? (Object?)
Dts.Variables("User::VStations").
May 30, 2012 at 10:01 am
Try this:
Dim arr() As String
arr = "636, 437, 618, 568".Split(",")
Dts.Variables("User::VStations").Value = arr
Stu
May 30, 2012 at 9:26 am
Referring back to my prior post:
"The crucial part was to set up the object as an Array, rather than an ArrayList."
Can't remember back why this was...
Stu
May 30, 2012 at 9:17 am
Sounds like you are ignoring the zeroeth element of the array. Does your code for populating the array look something like this?:
Dim MyArray(4)
MyArray(1) = "One"
MyArray(2) = "Two"
MyArray(3) = "Three"
MyArray(4)...
May 30, 2012 at 8:21 am
I got the same error whilst trying to execute a package from SSMS on the client. The assumption was that the package would run on the server with server...
January 12, 2010 at 5:20 am
Viewing 6 posts - 1 through 6 (of 6 total)