shafirmubarak (4/15/2014)
Thanks for your quick response.I would like to import as it is. I dont want to ignore the rows which has null GUID.
It's acutally child records which may sometimes doesnt have a GUID associated with it.
I didn't say anything about ignoring rows.
If the field is empty in the flat file, it can be imported as a NULL value.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP