Try something like this

BEGIN TRY
    IF NOT EXISTS (
            SELECT 1
            FROM dbo.view_MyView
            WHERE MemberID = @MemberID
            )
    BEGIN
        THROW 50000
            ,'MemberId does not exist'
            ,1;

Steve has got it right, despite his 'not much of an SSIS guy' disclaimer 🙂

Use a FOREACH loop to process the file, even though you know that there...

While I am sure that there are good reasons for doing so on occasions, including DDL to modify your database schema within a stored procedure is not best practice. For...

Can you try changing the connections from project level to package level?

Which version are you using?