Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  Update Table with content of document directory

Author  Topic  onmyway Starting Member 1 Post Posted - 2012-05-22 : 04:05:06 Hi All, I hope someone would be able to help me. I need to write a process in SQL Server that will: 1. Read through a specific directory and update a specific table with the path of each document in a specific directory, 2. as well as update the name of each of these documents. 3. Store each document in ExampleDB_DocLib (document_storage_tbl) linking it to the document_tbl. Column document_pk is the link. 4. It must be a scheduled task in the SQL Agent. The documents are in the following directory: • D:\Documents_1\Documents_2 This directory path is mapped in the Example database (ExampleDB_Example_2005) in table document_tbl and the documents are stored in ExampleDB_DocLib in table document_storage_tbl. Thanks!