Read an object variable having “FileInfo” object content.

I'm trying to loop and read an object variable(as shown in the pic) where it has the file details(name/size/datemodified) from a share point location. (The varible is passed from an SSIS -Sharepoint task to SCript Task)

I found that an object cannot be used in a foreach enumerator, and i'm not sure how to proceed with this one. Any help is much appreciated.

using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;
using System.Data.OleDb;
public void Main()
{
String Filename = "";
Var fileinfo = Dts.Variables["User::DvarObj"].Value;
foreach(var i in fileinfo)
{
Filename = i.Name;
MessageBox.Show(Filename);
}
Dts.TaskResult = (int)ScriptResults.Success;
}

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

GOWTHAM RAMAMOORTHY6y ago
Found the solution:

public void Main()
{
var fileinfo = Dts.Variables["User::DvarObj"].Value;
Dts.Variables["User::Local"].Value = new List();
List OutputFileNames = (List)Dts.Variables["User::Local"].Value;
string outputresultnames = "";
foreach (object element in (fileinfo as IEnumerable ?? Enumerable.Empty