So, what should I do?

Technical I want to exclude those records when BOTH COLUMNS are NULL

Any advise?

I am using AND not OR. Correct me If I am wrong.

WHERE CID IS NOT NULL

AND MID IS NOT NULL

This means when both conditions met

if my query is

WHERE...

I am using 2008 R2 and 2014 and the SQL didn't work for me

SELECT * FROM Null_Table

WHERE CID IS NOT NULL

AND MID IS NOT NULL

Any advise what would be the...

Thanks Thom for your reply.

I am sure I am not Ignoring any errors.

Hi MM,

Thank You for your reply. I got this far to read the Multiple files. However, my Excel file has different Layout in each Sheets. I can successfully read...

Awesome Phil, It WORKS!

Thank You.

Thank You for your prompt reply GSquared, So I have to or best practice is Pick the first Option (in my question) and 2nd and 3rd that you recommended. For...

Thanks, Welsh/tindog.

Welsh, I wish it would be that easy to add Send Mail task 🙂

Tindog, Here what I did in past and why I want different this time. Redirect any...

I am calling my SSIS Package through .Net. User will pick up the file through UI and hit submit after hit submit SSIS Package executed.

DECLARE @BType INT;

DECLARE @BC_Date DATETIME;

DECLARE Order_CUSTOMER_Cursor CURSOR

FOR

SELECT DISTINCT MANAGE_O_id, @MANAGE_O_id

FROM #tempM

OPEN MANAGE_O_D_Cursor

FETCH NEXT FROM Order_CUSTOMER_Cursor INTO @MANAGE_O_id, @CUSTOMER_O_id

WHILE @@FETCH_STATUS = 0

BEGIN

IF (@C_O_id > 0 )

BEGIN

SELECT TOP 1 @BType = M_Order.BType,...

Thank You SSCommitted for your advice.

Thank You.

Thanks for your reply. This is one part of BIGGG SP. If I paste the giant SP everyone will confuse. That's why I just mention the part that I want...

In my case, I am using L.O.Join...

So Correct me If I am wrong or I understand right.... there is no choice for me, I have to use SORT Transformation in my case, right?

Thank You.

My Linking key is not ready in source, that's why I am using Derived column to make ready my Linking key for linking...

It is just a look up table, however...