Not the expected solution but restarting the server did the trick in my case.

The Env variable I have created is system variable. Also, this is a new server so someone else creating one is very remote. But I will verify just to make...

I am using this SQL within the data flow task of SSIS package. I am doing simple select from a stage table and inserting into the base table. Wherever date...

In a select list.

Thanks,

-Mohsin

Hi,

If you do not want to get into look up tables and stuff, try implementing bad data re-direction technique.

This way when you execute the package, all the duplicate rows will...

Are you able to send email directly from Database mail component in SSMS?

So the source and target column mapping would be as follows,

CHGF1 = R or P

Then mapping is

ACT03_ARM_Change_Type_1 = CHGF1

ACT03_ARM_Change_Code_1 = 1

ACT03_ARM_Change_Effective_Dt_1 = CHGD1

ACT03_ARM_Change_Amount_1 = CHGA1

ACT03_ARM_Change_Rate_1 = CHGA1/10

and...

Hi Paul,

Its not straight forward to use insert into ... Select clause statements.

I think you are not clear with the requirement. I have uploaded source and target table scripts along...

I have uploaded source table script (changeInfo.txt) and source table data in (changeInfo_text.txt) along with target table structures.

I am not understanding logic to start from.

Thanks,

-Mohsin

Copying from stage table to target table with conditions as specified above.

Basically select from stage and insert into target.

-Mohsin

Yes, this is a production server. I had tried running agent with service account, even then I am unable to get the email out from the sql jobs.

Also, when I...

Not on this server. None of the SQL jobs able to send email upon completion (success\failure).

However I have few other SQL Servers from where email works from SQL agent jobs.

I am able to receive email when I execute my script using 'NT AUTHORITY\SYSTEM' privileges.

I tried running the above script, however there are zero rows returning from the query.

Thanks,

-MMohsin

I am getting zero rows upon executing your query.