Here is the solution, May be someone want to know...

LEN(CellPhone) == 10 && !ISNULL(CellPhone) ? CellPhone : LEN(OtherPhone) == 10 && !ISNULL(OtherPhone) ? OtherPhone : OID

Yeh 100% agree. I have to do something to make this happen with your help 😀

I just want to download only where email is abc@hello.com (as an example) and download the attachment on network drive folder.

Is there any third party software doing this ?

Ok I got it.

I have to change Protection Level to DONTSAVESENSITIVE to use my .Config file. It is working fine without any issue.

Thanks....

I would say, 70/30 (Insert/Update).

Opps I should mention.

I am using so far two transformations ( Derived Column, Data Conversion)

Plus I am using SCD..

That would be next question. If I pick Second Option then...

Thanks for reply, would you mind if you send me Macro code or any steps that would be help me to achieve what you are suggesting?

Thank You.

Thank You so much for your prompt reply. I will run your sql to real data and I will let you know. Looks good right now.

Thank You.

I know, I can create SQL agent job and run that job through SP sp_start_job 'JOB Name', but How I can pass variable?

I really appreciate your time/hard work and awesome code.

Thank You!

Thank You so much for your reply and help.

It was just a sample data here is in detail sample file

Advert,Network,Program

Acorn,NULL,NULL

NULL,AC,NULL

NULL,NULL,Adult

Jame,Null,Null

Null,IC,Null

Null,Null,Young

Null,Null,Adult

Fix,Null,Null

Null,GM,Null

Null,Null,Kid

The first three rows are set of Advert = Acorn

Second...

Thanks for reply. I wish I can ask my client to provide different file. Is there any I can get the output that I need? through t-sql or SSIS?

Thank You.

Thanks for your help, got it I can use multicast for different file, how about ?

Source:-

Add, New, Pro, Len, Source

Acorn,Null,Null,Null,Null

Null,FC,Null,Null,Null

Null,Null,Day,Null,Null

Null,Null,Null,2:00,Null

Null,Null,Null,Null,Phone

Null,Null,Null,Null,Web

Destination File:-

Add, New, Pro, Len, Source

Acorn,FC,Day,2:00,Phone

Acron,FC,Day,2:00,Web

this format ?

Hi All,

Thank You so much happycat59, it solve my problem. This question answer by happycat59.

I am so sorry Koen Verbeeck, I didn't pay attention on 1% error, my total...

I solved this question, Please reply, if someone wants a simple Solution.

Thank You.