It's not easy! You might have to use a proper REGEX parser to get this working properly.

But it may help others if you take the time to provide your data...

And I feel stupid for not having double-checked the obvious solution!

May I ask why you need to do this? Seems like an unusual requirement.

I haven't tested this, but I think that the output is also of limited use (because the...

Use an Execute Process task to call DTExec?

I'm...

Call DTExec, with the relevant parameters (full file path is one of them).

Take a look here.

Hi Phil,

Thanks for your reply!  So does Visual Studio not work with sftp?  Right now the SSIS package just has the ftp setup with the connection manager and it...

If you don't mind spending some cash on a 3rd party product, Cozyroc's SSIS add-ons will help you do the job (and many others).

Take a look here & track...

Is the maximum number of columns as shown in the image, or can this vary?

As you have not provided DDL and DML to allow us to use your sample data, I will provide an outline solution only.

SELECT ...

FROM Table2 t2

WHERE t2.TransId in (SELECT TransId...

Sounds like you want an INNER join to DepartmentDate.

Add a

UNION ALL SELECT NULL, NULL

maybe?

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