Read an object variable having “FileInfo” object content.

Question

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; }

GOWTHAM RAMAMOORTHY · Answer

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 ())) { var type = element.GetType(); var props = type.GetProperties(); object result = props.First().GetValue(element, null); outputresultnames = (string)result; OutputFileNames.Add(outputresultnames); } Dts.Variables["User::Local"].Value = OutputFileNames; Dts.TaskResult = (int)ScriptResults.Success; }

GOWTHAM RAMAMOORTHY · Answer

But still figuring out, how to fetch the "Name" Filed value from the collection and add it to a list variable.

GOWTHAM RAMAMOORTHY · Answer

Yes I changed the object to collection and trying to loop throught it to get the filenames. 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; var collection = fileinfo as IEnumerable; if (collection != null) { foreach (var item in collection) { OutputFileNames.Add(item); } } var id = fileinfo.GetType().Name; Dts.TaskResult = (int)ScriptResults.Success; }

Amit Gupta · Answer

It is an object and you have to typecast it to get the output.

GOWTHAM RAMAMOORTHY · Answer

Sorry this explicit conversion is not working, OR (its missing libraries that i cannot use/reference it).

Amit Gupta · Answer

Use explicit conversion Var fileinfo = (xxx.SharePoint.Connection.FileInfo[])Dts.Variables["User::DvarObj"].Value;