great thank you for all your help and advice i will take it into account in the future. 

Thank you again.

thank you for the reply i have a couple of return question. 

1. is it more beneficial to use a join rather than a sub select in the case...

In response to your concerns regarding how time is handled in this case our back end system and billing is conducted using 15 minute intervals. On the technician side when...

This is the application code that is generated when the stored procedure is called and resulting in the "End time cannot be blank" error

FINEST|9864/0|Service cvsat-v3.521.3-dev|18-12-14 13:35:57|Performing Action...

Here is the code prior to that call 

CREATE PROCEDURE [dbo].[usp_add_TimeCardEntry]

    @p_EntryDate date,
    @p_TechBranch varchar(3),
    @p_TechNo varchar(4),
    @p_Tech varchar(50),
    @p_WO_Branch varchar(3),
    @p_WONo varchar(8),
    @p_WONo2...

just reran the exact same process and it completed successfully in VS and uploaded the photo correctly. no idea what is causing it to crash first time through and I...

the target folder is already created and will always be created prior to the export.

was able to get a user to insert a picture that cause the job to crash and was then able to go back in and run the package in VB...

I guess at this point I will have to wait until a user enters a record that it doesn't agree with and I will take that record over to my...

the cv_wo_xtd_imgs tables holds photos that are uploaded and I have an on insert trigger that calls a sql server job that in turn calls the SSIS package to export...

Thanks for the input I guess now I am curious why it only seems to fail sporadically and often times if I delete the image retake it and use the...

as an update I took the original file deleted it from my database and inserted a new jpg file with the exact same name and it ran successfully the second...

I think I have answered my own question. The EXCEPT operator returns DISTINCT records where the NOT EXISTS will return all records so when a DISTINCT clause was added to...