zarathustra >>> we use CA Autosys

we use dtexec, which when run in the context of a scheduler will respond to a kill statement.

if we kill the job in the scheduler it will kill the ssis...

we have found that DTSConfig files work great for storing the parameters for the database, as you don't very often move your application from one database server to another except...

thanks everybody for the tips, but let me do a little more explaining so that you are clear on the root problem.

i have 3 X 100 files coming in at...

to get the details you want about the books in your original query one option is to use the MAX(field) function. This option is less efficient, but will achieve...

to be sure i would recommend the following statement, that way your sure you always end up with 9 characters, if you input is less than 6 for some reason.

UPDATE...