Phil,

I have already fixed it.

Thanks for your help!

Phil,

it works great but without FileCode.

File code is string value, so I wrote @[User::FileCode]=='1'. Destination column is int.

I received an error that it can't convert unicode to non-unicode...

Hi Phil,

I need to return this number 20220501 if FileCode <>1.

Also I forgot  indicated the correct file name.

It should be ImportFile_UK_DumpXX_20220501_XX.

Hi,

I have such data as on the picture.

I have calculated value Difference and I need to order this calculated value..

As far as I read that it impossible to sort the...

Thanks! It works

Phil,

Could you please clarify where I can find it?

I didn't see such option in SQL Agent.

My bad.

Sorry.

P.S. @jeff Moden your method with cross apply works!

Thank you

Hi Thom,

Unfortunately, I have too old version - SQL Server 2008 🙂

Hi Phil,

1. I see only the message "Script was failed".

2.Not for sure how correctly I can debug C# code. I put breakpoint in the main function in C# code, but...

Hi Phil,

yes, I debugged the code and see that when the file with the name FARAN comes the package is down.

Looks like this code doesn't work good.

Hi Jeffrey,

I used string because there is some C# code and manipulation with source data. That's why I decided to left this format.

The main problem that I have not 20210707...

Hi, Phil

Yes, it's correct!

David,

thanks a lot!

It works

Regards,

Khrystyna

Hi David,

I as well can execute it.

For example , I have such value: round(0.57,0).

When the number less 1 it doesn't work.

As well I receive in this case decimal value...

Jeffrey,

I expected to see such table (with only two rows):

I don't want to see a lot of rows for user. I expected to see duration in general...