SFTP Remote File List - How to use result?

Nov 23, 2013 at 1:37 AM
Hello,
Thanks for a great set of tasks.
I am trying to "Remote File List" action of the SFTP task with SSIS 2012.
The Result Variable is set to a variable of type Object.

How do I use that variable in a Script Task (Visual Basic 2010)?

I tried:
    Dim oleDA As New OleDbDataAdapter
    Dim dt As New DataTable 
    oleDA.Fill(dt, Dts.Variables("FoundFileList").Value)
but it threw an error that my object variable (FoundFileList) is not an adodb recordset.

Any ideas?

Thanks,

Mike
Feb 27, 2014 at 2:07 PM
Please see the sample project in downloads section.
Oct 2, 2015 at 4:44 PM
Hi
the sample project does not work..
Using exactly the Script task you gave i get the error:

Error 1 Cannot apply indexing with [] to an expression of type 'Microsoft.SqlServer.Dts.Runtime.Variables'

You can see the same error on you sample project..

Any suggestion?


Thanks,

Antonella