Dynamic error returned when manager creating system objects in source database

Check what SQL dialect is used. When dialect is 1 then object names cannot contain any spaces, in SQL dialect=3 the object names are case sensitive.