asp.net error

Dr.Silly

Hi,

Executing an SSIS package within .net, which has a parameter.

I am getting an error, you're help would be appreciated.
"Error trying to write to a read-only variable, "CancelEvent""

The code I have is just this.

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim app As Application = New Application()
' Load the packages.
Dim p1 As Package = app.LoadFromSqlServer("ImportJobPKG", "myserver", Nothing, Nothing, Nothing)

p1.Variables(0).Value = FileUpload1.PostedFile.FileName
p1.Execute()
　
End Sub

Dr.Silly

Dr.Silly wrote: »

Hi,

Executing an SSIS package within .net, which has a parameter.

I am getting an error, you're help would be appreciated.
"Error trying to write to a read-only variable, "CancelEvent""

The code I have is just this.

ProtectedSub Button1_Click(ByVal sender AsObject, ByVal e As System.EventArgs) Handles Button1.Click
Dim app AsApplication = NewApplication()
' Load the packages.
Dim p1 AsPackage = app.LoadFromSqlServer("ImportJobPKG", "myserver", Nothing, Nothing, Nothing)

p1.Variables(0).Value = FileUpload1.PostedFile.FileName
p1.Execute()
　
EndSub

the error is on this line btw.
p1.Variables(0).Value = FileUpload1.PostedFile.FileName

thanks

Evil Phil

Can you post the error details?

Dr.Silly

Evil Phil wrote: »

Can you post the error details?

Thanks Evil Phil. Here they are

Dr.Silly

got it sorted, code below in case anyone else has same issue.


Dim app As Application = New Application()
' Load the packages.
Dim p1 As Package = app.LoadFromSqlServer("Package", "myServer", Nothing, Nothing, Nothing)
Dim vars As Variables
vars = p1.Variables
vars("myPath").ReadOnly = False
p1.VariableDispenser.LockOneForWrite("myPath", vars)
vars("myPath").Value = FileUpload1.PostedFile.FileName
vars.Unlock()
p1.Execute()