thanks for your response. I appreciate that.

I am using the batch file not the SQL agent. The batch file will be executed using an ESP job, so i have to...

Thanks everyone for your valuable suggestion.

I have considered all your suggestion. Will go with surrogate key as primary key and have an alternate key to enforce uniqueness and business...

Yes, the unique enforcement would be absolute necessary.

But i was not sure how surrogate key will be of use?

Thanks,

For example, user id is used as a linkage across multiple tables.

I am concerned about defining a key for the child tables as it requires 3- 9 columns to...

Perfect that helps, Thanks everyone for looking into this,

It is resolved and I am closing this.

Resolution :

It got resolved by setting the property

"Retain null values from...

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...