I think not. You should really test things before posting them here. Using a precision of 0 causes immediate rounding to the nearest whole number.

This example seems over-simplified, to the point of being impractical.

To implement this in the real world, I'd be looking to develop a standard BOM model ... see here, for...

Is this a blog post, or do you have a question?

I took this from https://regex101.com/:

The point being that the string which you are extracting does not even match the expression from which it was extracted. How...

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?