Thank you for clearifying this, ARUN SAS.

Obsc.

Rollbacks are nice to have if you've done an error, ex deleted something without the where clause. just issue a rollback command, and the previous deletion is rolled back. What...

Should there be continously scanning? Quick scanning or complete scanning? Real-time scanning?Any folders/files to exclude?

I'm only installing a client on the server, can this be done otherwise?

Obsc.

I've tried the SSIS approach, but keep running into problems ( data conversion problems, flat file source doesn't allow XML file as input)

I came to the comclusion that TSQL would...

Yes. "Is SSIS installed on this server?"

Obscurr

Anyone? Is this an issue or is this unimportant?

Tor