@balupad14: I realized that missing parameter, but it didn’t help. So, I chose an alternate way to resolve it.
Alternative summary for community’s benefit: I explicitly invoked connect activity with data source and then passed the SQL through a variable into Non Execute Query activity step. This eventually worked for me !