SSIS Package Help XML Involved

See more:

SSIS

Hi Friends,
I'm very new to script. Using SQL Server BIDS 2005 i need to create a package involved below steps.

1. I need to watch folder for my Log files(.LOG files has xml data)
2. I need to pick two vals from XML log file (Id and status)
3. Using id value i need to update my database table.

Do i need to use script for the parse xml (.LOG) file.
I'm planning to use for each loop to watch folder, where LOG files will be available timely.

Anybody can help me plz... this is very urgent.

Thanks in advance.