#6425: Export Data --> MS SQL SERVER 2012 -> Table with all datatypes giving issues exporting

ivangron reported 2012-02-09T21:59:12Z · last modified 2012-04-28T00:14:29Z

Export Data --> MS SQL SERVER 2012 -> Table with all datatypes giving issues exporting

Dev	NielsGron
QA	ivangron

Priority	Low
Complexity	Unknown

Component	App - General
Version	11.0

Trying to export data via gui or via fluid shell is giving me issues in sql server. I created a table in database northwind called datatypes and filled it with data. exporting via query works but via table most rows fail.

attaching screen shots...

server info:

host: 10.168.11.80:1433

sa/******

driver param:: ?ssl=required

same table exporting via query below works

SELECT col_bigint,col_binary,col_bit,col_char,col_date,col_datetime,col_datetime2,col_datetimeoffset,

col_decimal,col_float,col_hierarchyid,col_geography,col_geometry,col_image,col_int,col_money,

col_nchar,col_ntext,col_numeric,col_nvarchar,col_real,col_smalldatetime,col_smallint,col_smallmoney,

col_sql_variant,col_text,col_time,col_timestamp,col_tinyint,col_uniqueidentifier,col_varbinary,col_varchar

FROM [northwind].[datatypes]

not sure if this will help you but i used queries simular to this to get the data into the table:

INSERT INTO [northwind].[datatypes] (

[col_bigint], [col_binary], [col_bit], [col_char], [col_date],

[col_datetime], [col_datetime2], [col_datetimeoffset], [col_decimal], [col_float],

[col_hierarchyid], [col_geography], [col_geometry], [col_image], [col_int],

[col_money], [col_nchar], [col_ntext], [col_numeric], [col_nvarchar],

[col_real], [col_smalldatetime], [col_smallint], [col_smallmoney], [col_sql_variant],

[col_text], [col_time], [col_timestamp], [col_tinyint], [col_uniqueidentifier],

[col_varbinary], [col_varchar])

VALUES (RAND(999999999), 0x38, 0x84, 'c', getdate(),

current_timestamp, SYSDATETIME(), current_timestamp, 65432112.5, 4321.35,

'/1/2/3/4/', geography::STGeomFromText('LINESTRING(-122.360 47.656, -122.343 47.656)', 4326), geometry::STGeomFromText('LINESTRING (100 100, 20 180, 180 180)', 0), null, 123123,

65, 'nchar', 'ntext field', 123765.56, 'nvchr',

100, getdate(), 432, 12, 'sql variant field',

'text field', current_timestamp, default, 124, NEWID(),

0x10, 'vchar')