Exporting to Sql server
The column names in the table in Sql server contain spaces. I cannot seem to export the worksheet
Does the column names in the workbook should be exactly the same as the sqlserver...meaning case sensitive and data type.
I have 5 columns in the workbook but 4 columns in the sql server. In the mapping tab of the export I told it not to include the colum but I get the first column a couple of times stating the columns need to be unique. I have to manually map them...
I even created a duplicate sheet with 4 columns but the mapping gave me the same error
-
Hello Bhupinder.
Are you trying to export data into the existing table? In this case, column names and datatype mapping is important. While it might still handle the name case, different column name or data type will cause the Exportjob's failure. As well, Datameer doesn't allow spaces in column names.Could you let me know, please, what exactly error do you observe and how the target table looks like?
You also might want to login to support.datameer.com with your corporate email and raise a support ticket to get this concern addressed. This will be a more convenient way of communication. -
Hello Konsta
It is an existing table in sql server. I have placed a support ticket using my corporate email.
I had to create new table in sql server to create columns without spaces.
I had to map the column names in the mapping tab manually to get the export to run...
When I open the export job the mapping tab shows the same error....I need to schedule the job to be run monthly.Do i have to map it everytime manually
Sql server
datameer workbook:
mapping tab
Please sign in to leave a comment.
Comments
3 comments