sqlsql-serversql-server-2008-r2sap-bw

SQL Server 2008 R2: Import table from text file when column names have a / in them

How do you import a table into a database from a text file when that table has /'s in the column names?

I have a SQL Server 2008 R2 table with columns that have /'s in their name. (SAP Database) For example: /BIC/FIC_SD001 has a column named /BIC/O_CST_00.

I have done an export (using the Import/Export Wizard) of this table to a text file and the slashes are there.

When I import the table into a different database (using the wizard) all the /'s from the column are removed and replaced with spaces. The above column now looks like this: BIC 0_CST_00

Thank you in advance for your help!

Solution

  • In the step of the wizard called Select Source Tables and Views, you have to click Edit Mappings... Over there you can manually change the Destination column names (setting back the missing slashes).