- Thank you received: 0
System.Data.OleDb.OleDbDataAdapter.Update insert empty row
- dburtsev
- Topic Author
- Offline
- User
-
Less
More
4 years 8 months ago #14503
by dburtsev
System.Data.OleDb.OleDbDataAdapter.Update insert empty row was created 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
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.
- dburtsev
- Topic Author
- Offline
- User
-
Less
More
- Thank you received: 0
4 years 8 months ago #14504
by dburtsev
Replied by dburtsev on topic System.Data.OleDb.OleDbDataAdapter.Update insert empty row
Attachment 1
Please Log in or Create an account to join the conversation.
- dburtsev
- Topic Author
- Offline
- User
-
Less
More
- Thank you received: 0
4 years 8 months ago #14505
by dburtsev
Replied by dburtsev on topic System.Data.OleDb.OleDbDataAdapter.Update insert empty row
Attachment 2
Please Log in or Create an account to join the conversation.
Time to create page: 0.171 seconds