Tried loading my data and got the same error.
Then tried SET IDENTITY_INSERT dbo.tblTransactions ON again and it said: Cannot find the object "dbo.tblTransactions" because it does not exist or you do not have permissions.
Strange since I have full admin rights on this DB