Search found 2 matches
- Thu Oct 04, 2012 12:22 pm
- Forum: General
- Topic: Stored Procedure with Return Value
- Replies: 3
- Views: 892
chulett - Thanks for the input! Your point about Parallel vs Server jobs is well taken, I'll bring that up with my teammates. I think I must have some confusion over the flow of the job that processes the file. Here is what I must do: 1) Detect a file on the filesystem (done by OS command in a Routi...
- Thu Oct 04, 2012 9:20 am
- Forum: General
- Topic: Stored Procedure with Return Value
- Replies: 3
- Views: 892
Stored Procedure with Return Value
I'm attempting to create a process that will loop over files in a given directory, record audit metadata about those files in an audit table, and lastly write the contents of those files into one or more tables. Currently, I have a sequence job that loops over a list of files in the directory (obtai...