Populating a Global Variable Output Rowset using ActiveX Script

[GJP55]

Is there a way to populate a Global Variable Output Rowset using ActiveX Script ?

I am trying to populate a global variable called SourceFiles with file names taken from a specific directory. I have code to find the file names but can not find a way to populate this to the global variable.

Once I have this, I can then step through the rowset and import the files individually.

Thanks

 

[SimeonJ]

set your code to find the file names as a variable (something like "vFilePath") then use the code below:

DTSGlobalVariables("SourceFiles").Value = vFilePth


When you want to reuse the data inserted into the global variable you will assign the global variable to a variable (like shown below) and insert that variable where needed

vPth = DTSGlobalVariables("SourceFiles").Value