Hmmm, ok, how do I use SSIS then. I'll have to start learning that one. I am new to SQL so was just mucking my way through things. I'll see...

Well, on the SQL server I have a folder and it is shared with a group. In that folder are subfolders and in one of those subfolders is the file....

Ok, on the SQL Server this .bat file works:

sqlcmd -S MyServerName -E -d MyDatabase -Q "EXEC MyStoredProcedure"

The server is let's say: \\Server1My program to run the bat file is on...