Using the SQL Server Import and Export Wizard with K2 SmartObjects

  • 16 February 2021
  • 0 replies
  • 82 views

Userlevel 5
Badge +20
 

Using the SQL Server Import and Export Wizard with K2 SmartObjects

kbt132297

PRODUCT
K2 Five
K2 blackpearl
BASED ON
K2 blackpearl (all)
TAGS
ADO.NET Data Provider
Microsoft SQL
SmartObjects
This article was created in response to a support issue logged with K2. The content may include typographical errors and may be revised at any time without notice. This article is not considered official documentation for K2 software and is provided "as is" with no warranties.

Issue

When attempting to use the SQL Server Import and Export Wizard to import K2 SmartObjects into a SQL table an error occurs.

Symptoms

When attempting to import K2 SmartObjects into a SQL table via the SQL Server Import and Export Wizard, the following error occurs:

 

Image

Resolution

Make sure you configure your SQL query as follows:

 

Image

 

 

Make sure to set the character length to max - once you do this you will be able to import the data successfully

 

Image


0 replies

Be the first to reply!

Reply