This might work.

INSERT tUser (Name,Email)
SELECT DISTINCT Name,Email
FROM tUSER_NEW tnew
WHERE NOT EXISTS (SELECT * FROM tUser t where t.Email = tnew.Email)

But if the same e-mail exists in tUSER_New...

Your code does not 'skip' anything, nor is there any concept of anything 'running until the end'. Can you state the problem more clearly? Feel free to add sample data...

Please provide sample DDL, INSERT statements and desired results (based on the sample data provided) if you would like people to provide a working solution.

I rarely use absolutes, but I feel comfortable using one here.

Given the generic nature of that error message, no one here is going to be able to solve this for...

Jeez, 13150 points and you still haven't learned how to present your code in a code block.

All you need to do is click on the Insert/edit code sample button...

Great, my pleasure and thanks for posting back. So many people just disappear without trace once they have a solution.

With thanks to Itzik Ben-Gan for the inline tally table, how about this?

DECLARE @Day TINYINT = 4;
DECLARE @NumberOfPayments INT = 20;
DECLARE @StartDate DATE = DATEADD(DAY, @Day -...

Every month since when? Until when?

Please read this article.

It's a lot easier to view the run logs from the All Executions report than by querying SSISDB directly.

"I need a way to calculate, the date of every month, for whatever combination that they send in here."

Not sure what this means. Define 'every'. Something like this?

            
April 24, 2020 at 1:29 pm
            
#3746012

            
            
                                                
        

You've been here long enough to know the drill. Please provide sample DDL, INSERT statements and desired results if you want others to write SQL for you.

"While seeing the operation log found that it is getting failed on "OnPostExecute"step."

Please describe what this 'operation log' is, thanks.

Can you include the file sizes in the screen shot?

Are you saying that the only error for this package, as appears in the All Executions Report, is this one:

'Exception has been thrown by the target of an invocation'

?

That would...

• This reply was modified 5 years, 9 months ago by Phil Parkin.
• This reply was modified 5 years, 9 months ago by Phil Parkin. Reason: Typo fixing

You used the terms security and XP in the same sentence, and that's...