It's been a while since I have done this, so I can offer only limited help.

I would say that LIKE is definitely not going to work in this case. You...

SSIS failing  if server not accessible - I use 2008

I have an SSIS package which captures data from across servers using a for each loop container as long as...

Sure. This join

on StrutturaOrganizzativa.descrizione=Negozi.fk_responsabile

is the problem, because you're trying to match a string and an integer. Columns which you JOIN on should ideally have the same datatype.

Here's my test script.

DECLARE @i DECIMAL(5, 3) = 0;
DECLARE @Inc DECIMAL(3, 2) = 0.01;

WHILE @i < 2
BEGIN
    PRINT CONCAT(@i, ',...

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...