What is the datatype of the ID column?

As an aside, calling columns 'ID' is rather bad practice, as it provides no hint as to what sort of ID it is.

Being...

Hopefully I've attached all the code you need.

As in 'none at all'?

Very difficult to help without more info!

Alternatively

SELECT ROUND(@TestNumber + 0.3, 0, 1);

Will this work?

SELECT ROUND(@TestNumber - 0.2, 0);

convert(varchar,mydatefield,101)

Do you prefer this over the more intuitive (in my opinion)

cast(mydatefield as date)

?

Getting row counts using that transformation requires reading every row...

When you use SSIS to call procs which return data from one or more temp tables, you need to add a WITH RESULT SETS definition to your EXEC PROC call,...

If the Comments argument is sometimes not being passed at all, you can default it like this

ALTER PROCEDURE [dbo].[APUpdateComments]
(
  @DocID varchar (50),
  @ID varchar (50),
...

That is an unsatisfying resolution!

You should probably attend to those truncation warnings ... one day, when your input data changes, they'll turn into unhandled errors.

I could, but that would mean I was doing your job for you.

How about you...

You want only the counts, not the data in the files?

Use a Script Task to get the counts

var rowCount = File.ReadLines(file).Count();

and write that out to a file of your choice...

Does the All Executions report give you any additional information? It should tell you exactly which component is failing, for example.

Am I missing something obvious here?

The Job is...

Thanks Phil for your quick response and if its detected that will help for application team to check it further.

even we can avoid any issues from  SQL server side

I...

I'm with Thom.

Sounds like a Flat File Source, to a staging table, followed by one or more ExecuteSQL tasks to fire off the stored procs you need to process the...