I tried the code that was suggested in the visual basic 2008 script and get an error for the following statement:
Dim input_file As New FileInfo(Dts.Variables("FilePath").Value.ToString)
The error is "Type 'FileInfo' is not defined."
Do you have an answer for that?