All of the program code and information presented in the OpenNTF.org Code Bin are provided "as-is", and should be used at your own risk. OpenNTF.org make no express or implied warranty about anything in the Code Bin, and OpenNTF.org will not be responsible or liable for any damage caused by the use or misuse of anything from this site. OpenNTF.org makes no guarantees about anything. Please thoroughly test all of the knowledge and code you find here before you attempt to use them in your production environment.

So the SQL Server guy stop by and says, "Hey, we want to create some reports of Notes data and we only know how to use SQL Server to do it. Do you mind exporting it to a delimited text file and saving it to this restricted folder on the file server? Here's the username and password of a special Windows account with rights to the folder. Oh, and we need it to run on a scheduled basis so everything is automated. Thanks!"

The key here is the use of an alternate username and password to gain access to a restricted folder on a Windows file server.

Note: This only works on Domino servers running on Windows.
Read more:
http://www.lotusguru.com/lotusguru/LGBlog.nsf/d6plinks/20080530-7F5HBT

There is one Script Library and two sample agents showing typical use cases. One agent exports tabular Notes data as a delimited text file. The second detaches files from Notes documents to the target folder.