Skip to main content
Solved

SQL Server Table issue

  • April 4, 2013
  • 1 reply
  • 8 views

Hi FME-ers,

 

 

I am experiencing an issue with the following:

 

 

I have two identical tables in MSSQL Server 2008 (one table copied from the other).

 

 

 

When I use the FME MSSQL Server writer to copy data from one table to the other, I get the warning:

 

 

 

SQL Server Writer: Attribute ‘FIELDNAME1’ of feature type “TABLE1’ has specified type ‘nvarchar(10)’, but existing database table field has type ‘nchar(20)’.  Information may be lost during conversion.

 

 

 

The field type is in fact nvarchar(10) in both the source and destination tables.  Any ideas why this warning occurs?  These warning messages are only occurring where there are nchar and nvarchar field types in the table. I have two identical tables in MSSQL Server 2008 (one table copied from the other).

 

 

 

any ideas?

Best answer by david_r

Hi,

 

 

it might be that the destination feature type definition in FME differs from the table definition in MSSQL. If you haven't done so already, I recommend that you delete the output feature type and import it from the destination table.

 

 

You will find the option to do this under Writer / Import feature type.

 

 

That is the best way to ensure that your output feature types in FME matches an existing schema defintion on the target side.

 

 

If the error persists, it would be helpful if you could post a screenshot of the output feature type defintion as well as the table defintion in MSSQL.

 

 

David
View original
Did this help you find an answer to your question?
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

david_r
Celebrity
  • Best Answer
  • April 5, 2013
Hi,

 

 

it might be that the destination feature type definition in FME differs from the table definition in MSSQL. If you haven't done so already, I recommend that you delete the output feature type and import it from the destination table.

 

 

You will find the option to do this under Writer / Import feature type.

 

 

That is the best way to ensure that your output feature types in FME matches an existing schema defintion on the target side.

 

 

If the error persists, it would be helpful if you could post a screenshot of the output feature type defintion as well as the table defintion in MSSQL.

 

 

David

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings