I'm using version 2008 R2. In my SSIS package I have a for each loop container that reads multiple xml files and inserts data into sql tables. That works fine....

When I try adding Imports Microsoft.SqlServer.SmoExtended to the visual basic 2008 script contained in this article, I get the following error:

Namespace or type specified in the Imports 'IO.System' doesn't contain...

When I try adding Imports IO.System to the visual basic 2008 script contained in this article, I get the following error:

Namespace or type specified in the Imports 'IO.System' doesn't contain...

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...