Skip to main content

Hi,

 

I am using the ExcelImportService dll to import the Excel sheet into the SQL Table through the smart object.

But date values are not writing to the SQL table....just showing as Null. But all other like varchar, money are working fine.

 

I have debugged the c# code through attaching to the K2 service but still no luck....it is showing everything fine and then fails after executebulkscalar () method.

No luck in the SQL Profiler either since it is BULK INSERT.

 

Any ideas or any one experienced this before?

 

Thanks

Rao

Rao


 


My suggestion would be to look at how you are inputing the dates and what the actual data type is. There are 3 types of time based data types that we support, Date, Time, and DateTIme. I would check to make sure which data type you are inputting, From there, check the actual format of the input data to make sure that it matches the correct input format.


 


Ian

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings