Like you mentioned, "Files" is a variable of type Object.

What is happening in the script is, I'm taking a given directory, and looping through all of the subdirectories in that...

thanks. I can see the logic now. You have declared Files as object variable. could you explain me the script below:

' Microsoft SQL Server Integration Services Script Task

' Write scripts...

hi

thanks for sending this. I dont think i can change anything..it just opens as an executable file. and when i try to execute it asks for path..can i see it...

Thanks.

I agree that foreach loop container is the best option to loop through the folders. What I am unsure of is the script component to identify which folder path...

Hi,

Just curious to know before you did 'execute sql task' how did you provide the source that provides the data into sql task? My problem is similar to urs, and...

thanks. i will follow this in future. just ran out of time this time.

regards,

debra

thanks for your help, i will post the file tomorrow if possible. else its okay. I will find a way around. I know I have been unable to explain. It's...

Sorry I don't have the time to explain anymore. I know you are also busy. It's okay. I will find a way around.

Kind regards,

Debra

thanks..

no that would update everything..while i want a.the last session time and b. if last session time placement = criteria i gave before then find the last session where...

if i provide you the text file, would you be able to import that to do the logic? I really dont have the time to make it in this format.

sorry to come back again, but my problem is not getting solved.

Here is what i need to archive:

1) If last session MMC_PLACEMENT = LM_"YOUR CTA NUMBER" ...

this does make more sense to me..i will try the code..and get back to you..thanks for posting this,,,:-)

debra

the only problem i see though i have not tried this.is that it might update everything..and i want only the last one to be updated

thanks..i will try this one and let u know.