Just I'm wondering did you try to keep the column name inside opening and closing square brackets ?
Some thing like [Membership Campaign]. As you know, we can point to columns' name that contains
space.

SELECT [A test], [My Name]
FROM [myDB].[dbo].[Table_1]

Anyway, I don't have idea about your Business Layer Generator, then you did a good job if it works fine now.

> Oh, and to followup, I renamed the column to include an underscore, and everything worked fine.

> EXEC sp_rename
> @objname = 'tblMember.Membership Campaign',
> @newname = 'Membership_Campaign',
> @objtype = 'COLUMN'