Hi All,
In one of my ScriptTasks, I instantiate FileSystemWatcher class and set events for it. This has been done inside the Main() method. I can access all the varibles declared in the SSIS package inside the Main() method (by using Dts.Variables("").Value) but none can be accessed inside the event methods. One possible reason for this can be, events might be running in different threads.
Now my question is, How the varibles can be accessed inside the event methods.
Hope someone can give me a solution. Appricate all your solutions.
Thanks
You might want to try using Daniel Read's method of accessing variables here:
http://www.developerdotstar.com/community/node/512
If that doesn't work, then it must be a thread-locking problem, although I can't see how that could really happen.
HTH|||
hi,
How odd, I've tried this snippet of code and it works fine:
Public Sub Main()
uno()
Dts.TaskResult = Dts.Results.Success
End Sub
Public Function uno()
MsgBox(Dts.Variables("RutaFicheroCarga").Value)
End Function
|||Hi,
I tried the Daniel's method but it didn't work for me. The actual code looks like below.... to show you the exact problem.
Public Sub Main()
Dim watcher As New FileSystemWatcher()
......
......
AddHandler watcher.Created, AddressOf OnChanged
......
......
Dts.TaskResult = Dts.Results.Success
End Sub
Private Sub OnChanged(ByVal source As Object, ByVal e As FileSystemEventArgs)
Try
MsgBox(Dts.Variables("MyVariable").Value.ToString()) ' this gives the error "Object reference not set to an instance of an object"
Catch ex As Exception
MsgBox(ex.Message.ToString())
End Try
End Sub
Looking forward to seeeing a solution for this.
Thanks
|||What is the data type of MyVariable? You may need to convert it to the Object data type.|||Have you tried changing the Private modifier on your sub to Public?SL Coder wrote:
Hi,
I tried the Daniel's method but it didn't work for me. The actual code looks like below.... to show you the exact problem.
Public Sub Main()
Dim watcher As New FileSystemWatcher()
......
......
AddHandler watcher.Created, AddressOf OnChanged
......
......
Dts.TaskResult = Dts.Results.Success
End SubPrivate Sub OnChanged(ByVal source As Object, ByVal e As FileSystemEventArgs)
Try
MsgBox(Dts.Variables("MyVariable").Value.ToString()) ' this gives the error "Object reference not set to an instance of an object"
Catch ex As Exception
MsgBox(ex.Message.ToString())
End Try
End SubLooking forward to seeeing a solution for this.
Thanks
Also, you have to make sure that your variable is indeed instantiated. What is the type of your variable? If it is a reference type, it has to be somehow somewhere declared as New.|||
It is a string type variable and it can be accessed in Main() method without any problem. I made the event method as public but no luck. Also note that variable has been added to SSIS with scope of the "project". This problem not just for this variable, No variables can be accessed through the event method.
Any suggestions?
Thanks
Dim watcher As New FileSystemWatcher()
Shouldn't it be:
Dim WithEvents watcher as New FileSystemWatcher()|||
Not sure why it does not work, but I have found writing custom tasks is often easier when trying anything other than simple stuff, if only because I can choose my language, and the IDE is much better. Not much use, but perhaps this would be -
File Watcher Task (http://www.sqlis.com/23.aspx)
|||Hi Jon, Darren
Thanks for reply. I tried with WithEvents but it didn't work again. I have tried FileWatcherTask (sqlis) before but one biggest problem with it is, it stops listening once the first file is detected.
l'll try to make a custom task and see.
Thanks
