Hi All,
Here is a utlity that you might find in handy if you are dealing with the WSI automation interface:
http://www.simrun.com/AspDotNetStore...Commander.aspx
Its a utility that allows you to processs csv file and perform inserts/updates/deletes into your database. YOU can schedule task to happen repeatedly as well.
A Custom SQL statement tab is available also can be scheduled to run repeatedly and export its results via a CSV file.
The app is free, just fill out the key request form to get a license key (you can run the app without the license key too, but its limited to 50 records).
NOTE: This has been tested with winxp and vista, windows 7 is a little buggy and will be fixed in a future release. Also note make sure you have .net 2.0 and wse3.0 installed on your machine (check the link above you can download it by scrolling to the requirement box).