Is this a right mail group for System.Data.SQLite ? -----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Burtsev, Dmitriy Sent: Thursday, January 05, 2017 9:08 AM To: 'sqlite-users@mailinglists.sqlite.org' Subject: [sqlite] Need help with System.Data.SQLite.SQLiteDataReader and NUMERIC(5, 5) column
Hello I got this error: Exception calling "WriteToServer" with "1" argument(s): "The given value of type SqlDecimal from the data source cannot be converted to type decimal of the specified target column." How to reproduce. 1. On SQLite execute this statements. CREATE TABLE FromNum ( id INT, Num NUMERIC(5,5) NULL); INSERT INTO FromNum (id, Num) VALUES (1, .00000); 2. On MS SQL Server 2014 (SP2) execute this statement CREATE TABLE dbo.ToNum ( id INT NOT NULL , Num NUMERIC(5,5) NULL); I can't copy my PowerShell script in this e-mail. Got error "The message's content type was not explicitly allowed". I will try pseudocode. Add-Type -Path '\\SERVER01\SQL\SQLite\netFx46\System.Data.SQLite.dll' Create System.Data.SQLite.SQLiteConnection Connection CreateCommand() CommandText = "SELECT * FROM FromNum" System.Data.SQLite.SQLiteDataReader = Command.ExecuteReader() Create System.Data.SqlClient.SqlConnection Create System.Data.SqlClient.SqlBulkCopy with [System.Data.SqlClient.SqlBulkCopyOptions]::TableLock bulkCopy.BatchSize = 5000 bulkCopy.DestinationTableName = "ToNum" bulkcopy.EnableStreaming = true bulkCopy.WriteToServer(SQLiteDataReader) <-- Got error here Note: I did run it with System.Data.SqlClient.SqlDataReader as a source. It works with NUMERIC(5,5) column. I did run it with System.Data.SQLite.SQLiteDataReader but without NUMERIC(5,5) column. It works. The problem appears only when I run SQLiteDataReader as a sourse and table have NUMERIC(5,5) column. Powershell version 5, 64 bit System.Data.SQLite.dll version 1.0.103.0 64 bit .NET Framework 4.6.1 Thank you Dmitriy Burtsev This message, and any of its attachments, is for the intended recipient(s) only, and it may contain information that is privileged, confidential, and/or proprietary and subject to important terms and conditions available at http://www.stifel.com/disclosures/emaildisclaimers/. If you are not the intended recipient, please delete this message and immediately notify the sender. No confidentiality, privilege, or property rights are waived or lost by any errors in transmission. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users