Hi,
thank you for your reply.
We do not have permission to do that.. so I have to find an alternative way to do this.
I am planning to create a hashkey in Stored procedure and have merge Statements to update/insert records.and then execute the Sproc using sql execute task.