Yes.

As stated you can use SSIS.

An SSIS For Each Loop Container and a Script Task with the File System Object will do it.

So what is not not working? How can we be of assistance to you?

If you create a trigger or a...

If you add a breakpoint on the Line of Code and place the mouse over the "Source_File_Path" it should display the path of the Access Database that you opened.

The ("Source_File_Path") should be the path of the Database that you currently have open.

'\\sqldump01\prisql01\' does not sound like a valid Server & Path (Share).

As was suggested the files would be moved from the location that you are transferring them from.

You may want to read the following article:

Forum Etiquette: How to post data/code on a forum to get the best help

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Try the following URL which has some links to articles that may be of help to you.

http://social.msdn.microsoft.com/Forums/en-NZ/sqlintegrationservices/thread/a9a48b4e-875b-4d32-b2b0-49e8f71e5a8a

I can't think of a reason that would necessitate SSIS.

The following link has some simple examples of Dynamic SQL.

http://www.sqlteam.com/article/introduction-to-dynamic-sql-part-1

Have you considered storing the recipients and the Where Conditions in Tables and dynamically generating the SQL Statements?

If the Indexes are heavily fragmented you will achieve better results by rebuilding the index as opposed to Reorganizing the index.

Post removed.

Is not a valid UNC Path.

Also make sure that the SQL server Agent Account has permissions to the correct path.