- Forum
- Main PGNP Forum
- Redshift OLE DB Provider
- System.Data.OleDb.OleDbDataAdapter.Update insert empty row
System.Data.OleDb.OleDbDataAdapter.Update insert empty row
4 years 4 weeks 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
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.
4 years 4 weeks 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.
4 years 4 weeks 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.
- Forum
- Main PGNP Forum
- Redshift OLE DB Provider
- System.Data.OleDb.OleDbDataAdapter.Update insert empty row
Time to create page: 0.062 seconds
- You are here:
-
Home
-
Forum
-
Main PGNP Forum
-
Redshift OLE DB Provider
- System.Data.OleDb.OleDbDataAdapter.Update insert empty row