I have a SQL Server 2005 Source table mapping to SQL Server 2008 R2 table.
The SQL Server 2005 column has an empty space in the field name.
eg [SampRequest ]
The field data type is char(50) on the database.
When I drag it across from the input frame in the query transform it is marked with a red x next to it.
I have tried double quotes and that has not resolved the issue.
Interestingly an integer datatype with an empty space works fine.
Anyone have any ideas?
chenp22 (BOB member since 2011-08-18)