The SNP Government has "tied themselves in knots to set themselves against this deal", according to the Scottish Secretary.