Hey Pati... It may just be a one timer.... but if the data looks good, it may be more frequent. it turns out some other process is taking records from this table, and may be removing them.... Part of the reason we are trying to get some snapshots of the data.
I'm trying not to write an app until I know if we need this data.
Is it really simple to use to do the menu picks? Doesn't seem like the end user is very experienced, nor am I on Sql Server.
If you think that you will need the same procedure again then you can save the DTS package for further use and then schedule it to run as desired.
...or then for another approach you could automate everything with scripts/scheduled jobs.
But as you're saying that you don't have much experience in SQL Server and that this might just be a one off solution then I would stick to DTS.