#10278: An option to suppress warning in data import while attempting to parse empty (not null) Date values

tariqrahiman reported 2013-10-01T15:53:22Z · last modified 2013-10-01T16:25:26Z

An option to suppress warning in data import while attempting to parse empty (not null) Date values

Dev	SachinPrakash
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	Tools - Import Tool
Version	Future

Improve the usability in the Data Import so that while importing null date values, an option to suppress warning Warning: Row: 1 -- Column:"Sdate" type:date :Unparseable date: "" --

1. The destination columns allow nulls and have been set the the MS-SQL Date data type.

2. An improvement in the data import from attempting to parse empty (not null) date values

when importing from flat file to MS-SQL server please?

To reproduce in MS SQL Server

CREATE TABLE [dbo].[iss_date_imp] (

[id] varchar(25) NOT NULL,

[Sdate] date NULL,

[Rdate] date NULL

)

Import with the attached file.

1 attachment

date.sql

2013-10-01T15:53:22Z

353 B

All Comments (1) Change History

tariqrahiman 2013-10-01T15:59:17Z

The thing to note is : It is just a warning. It imports the value as a NULL which is the correct value for if it is a "" on a date column.

Search Tips

Aqua Data Studio / nhilam

An option to suppress warning in data import while attempting to parse empty (not null) Date values

1 attachment

Issue #10278

Completion

Search Tips

Aqua Data Studio / nhilam

Title

An option to suppress warning in data import while attempting to parse empty (not null) Date values

1 attachment

Issue #10278

Completion