Search found 2 matches

by mhupman@citrrus.com
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...
by mhupman@citrrus.com
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...