Faculty of Engineering and Mathematical Sciences 
Not logged in (login)

help3401


This forum is provided to promote discussion amongst students enrolled in Data Warehousing (CITS3401).
 
Options:
RSS cloud
Jump to:

lab4 question

4 of 259 articles shown, currently no other people reading this forum.
photo
From: ANONYMOUS
Date: Thu 19th Mar 2020, 10:19pm
Actions: 
        Login-to-reply

 

Hi
I followed lab4 of bulk insert process, which is step 7, but failed by reported 
Unexpected NULL value in column1, even commanded out the KEEPIDENTITY. Did anyone 
encounter same situation as me?
Thanks

lab4 question

photo
From: Craig H.
Date: Fri 20th Mar 2020, 1:56pm
Actions: 
        Login-to-reply

 

Hi
I had the same issue. Go to the Column Properties, set the 'Identity Specification' to Yes 
for the primary key column in each table. After doing this the Bulk Insert process worked 
fine.

lab4 question

photo
From: ANONYMOUS  O.P.
Date: Fri 20th Mar 2020, 6:35pm
Actions: 
        Login-to-reply

 

thanks. I used the provided sql script to build the table then using the bulk insert would 
function normally.

lab4 question

photo
From: Craig H.
Date: Fri 20th Mar 2020, 9:29pm
Actions: 
        Login-to-reply

 

No worries
This Page


Program written by: [email protected]
Feedback welcome
Last modified:  9:57am Nov 18 2020