System.Data.OleDb.OleDbDataAdapter.Update insert empty row

More
7 months 2 weeks ago #14503 by dburtsev
dburtsev created the topic: System.Data.OleDb.OleDbDataAdapter.Update insert empty row
Migrating code from SQL Server to Redshift.
64 bit Powershell script.
This is the SQL Server table:
CREATE TABLE dbo.psql_test
(
id INTEGER NOT NULL,
varchar_255 VARCHAR(255),
date_dt DATETIME,
varchar_10 VARCHAR(10),
timestamp_dt DATETIME2
);
This is the Redshift table
CREATE TABLE mocsdw.psql_test
(
id INTEGER,
varchar_255 VARCHAR(255),
date_dt DATE,
varchar_10 VARCHAR(10),
timestamp_dt TIMESTAMP
)
DISTSTYLE EVEN;

Attachments - old working code for MS SQL LoadMSOLEDB.ps1
new code for Redshift LoadOLEDB.ps1

Old code insert new row into table.
New code insert empty row into table

Thank you,
Dmitriy Burtsev

Please Log in or Create an account to join the conversation.

More
7 months 2 weeks ago #14504 by dburtsev
dburtsev replied the topic: System.Data.OleDb.OleDbDataAdapter.Update insert empty row
Attachment 1
Attachments:

Please Log in or Create an account to join the conversation.

More
7 months 2 weeks ago #14505 by dburtsev
dburtsev replied the topic: System.Data.OleDb.OleDbDataAdapter.Update insert empty row
Attachment 2
Attachments:

Please Log in or Create an account to join the conversation.

Time to create page: 0.058 seconds
Powered by Kunena Forum