The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have a Fabric Lakehouse table that contains all string data types. I need to load the data into a new table with the correct data types. When I use the copy data activity, I receive an error message stating that null values in string columns cannot be inserted into an int column. How can I update these columns with actual null values, or is there an easier way to load the data with the correct data types?
Thanks
Solved! Go to Solution.
Hi @Soobramoney ,
For this type of problem, you can make sure that the columns are defined with the correct data types when you create a new table, and allow null values if necessary.
The following demonstrates the successful insertion of a NULL value in a table:
CREATE TABLE [NullCheck1]
(
col1 int not null,
col2 VARCHAR(30) NULL,
col3 VARCHAR(30) not NULL,
col4 int NULL
)
GO
INSERT INTO [NullCheck1] VALUES (3,NULL,'NA',NULL)
select * from [dbo].[NullCheck1]
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Soobramoney ,
For this type of problem, you can make sure that the columns are defined with the correct data types when you create a new table, and allow null values if necessary.
The following demonstrates the successful insertion of a NULL value in a table:
CREATE TABLE [NullCheck1]
(
col1 int not null,
col2 VARCHAR(30) NULL,
col3 VARCHAR(30) not NULL,
col4 int NULL
)
GO
INSERT INTO [NullCheck1] VALUES (3,NULL,'NA',NULL)
select * from [dbo].[NullCheck1]
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.