Hello,

Thank you  for your reply. Yes. the columns were created according to what you have written. No need to change nothing from my side in relation to that.

Hello, error found. I was not doing the in comnination properly.

But if I had two additional columns just to guarantee that the file is able to be read. Would this be possible? For example at connection level or source level...

Solved. I found the right replacing function and with your help of having to replace commas in order to work, thinks are now solved. Thank you for the support

I think I am not doing the things right in terms of replacement of the comma by null

How do you replace "12,122,222.22" commas for notjing , so that...

Thank you for the support. It works

I have just poted another post as I may have additional issue, maybe some columns are not treated as they should because they are inside the excel (csv file) as

So its part of the flow , before I send it to the database

thank you for your answer.

Data is pulled using source flat file and after I have a derivated column (where I do the replace of the commas. After I...

Hello,

Thank you for your reply.

The value comes like this from excel file . which is a str (500). Then I am trying to have a...

its TFS. Yes. I have tried to delete from SSDT and from my workspace. then checkin. Then bring last version from the server . then create a new package with...

Hello, Thank you very much for your replies. This is str format column.

To put it working I had to create a devrivated column and put the below expression:

Hello,

Thank you for your reply. Problema. Is that the Soure file is excel, not sql.  So I cannot build a sql task

I mean, I need to find a way to replace the null for the name is order to be able to generate the aggregate without having two results.

But how can I do that? Can I replace the null values for the name of the manager when the aggregation is done?