Prev: need to establish sound backup/maintenace/security practices
Next: Precedence Constraint question
From: JJ297 on 6 Apr 2010 11:03
I added a script task to my ssis package to check last file modified
in Explorer. Here's the code:

Public Sub Main()
Dim fi As System.IO.FileInfo
Dim ModifiedTime As DateTime


If CInt(Dts.Variables.Contains("User::FileUpdatedActual")) = 1
Then

fi = New System.IO.FileInfo("\\sb25\downloads$\DataInfo
\DataInfo.txt")
ModifiedTime = fi.LastWriteTime
Dts.Variables.Item("User::FileUpdatedActual").Value =
fi.LastWriteTime.Date
Dts.Variables["User::bExists"].value = true
Dts.TaskResult = Dts.Results.Success
Else
Dts.Variables["User::bExists"].value = False
Dts.TaskResult = Dts.Results.Failure
End If


End Sub

I next added the two variables FileUpdatedActual and bExists. In the
script task I'm getting the blue squiggly line under:

Dts.Variables["User::bExists"].value = true

and

Dts.Variables["User::bExists"].value = False

The error message is:

Property access must assign to the property or us it's value. Any
suggestions?

 | 
Pages: 1
Prev: need to establish sound backup/maintenace/security practices
Next: Precedence Constraint question