Log errors where they occur.   Nesting stored procedures is problematic enough without adding additional complications.   Every stored procedure is best served when it entirely takes care of itself.   That is...

This query has already been answered elsewhere.   I know this because I and at least one other person answered that other post.  Here was my solution:
CREATE TABLE #test (

The filters can exist, but if you have the file saved after having actually used the filter to filter out rows, what you get might either be this error or...

First order of business is to decide exactly what data conditions constitute a duplicate.   Then write a query that identifies the existence or non-existence of those conditions by outputting only...

Somewhere in the package, a parameter named Server is expected to have a value that is not null.  If you can find that parameter and ensure it has a value...

Try this, and change the @Variable value as you see fit...
CREATE TABLE #TEST (
    Column1 char(1),
    Column2 char(2)
);
INSERT INTO #TEST (Column1, Column2)
    VALUES    ('A', 'B'),
            ('A', 'C'),
            ('A',...