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

More
4 years 8 months ago #14503 by dburtsev
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
4 years 8 months ago #14504 by dburtsev
Attachment 1
Attachments:

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

More
4 years 8 months ago #14505 by dburtsev
Attachment 2
Attachments:

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

Time to create page: 0.171 seconds
Powered by Kunena Forum