I need to import some MySQL tables into my MSSQL 2019 server and keep getting null errors. "An unexpected NULL value was returned for column deployment_date"
Here is the snip from the stored procedure.
=================================
CREATE TABLE dbo.RAP_project (
id int NOT NULL ,
address text ,
network int DEFAULT '0',
loc int DEFAULT '0',
analyste int DEFAULT '0',
csr_date date NULL,
deployment_date date NULL,
=================================
I've also tried deployment_date VARCHAR(20) NULL,
Thanks
Pete
PS forgot to add the actual insert from a linked server.
SELECT * INTO dbo.RAP_project
from [MYSQL_progmgt]...[dbo.project]