Thanks both,

To bitbucket-25253

I think your added statment only considers the target is null,

But how about the source end is Null, no matter what, I would like to...

Thanks, I am not using look up.

I have read the series before, it becomes quite complicated by using those.

I also read somewhere ever since SQL server 2008 has the new...

Thanks, the first article is certainly helpful for my future reference, but I just didn's see anywhere it mentions to handle pk or forign key...

GSquared (1/9/2012)

---

Can you run an SQL task before the Merge, after the staging load, that checks for rows in the staging data that would violate the constraint?

Update dbo.MyStagingTable

set RowCheck =...

I know I need to load the primary key table first, then load forign key table.

The problem is from the source flat files, sometimes they have data integrity issue, we...

Thanks , that works perfectly!

Paul, while I am trying above SQL, I got an error:

Msg 102, Level 15, State 1, Line 13

Incorrect syntax near '@T'.

Cannot figure out why?

Thanks

Thank you a lot.

It seems Merge statement is a very helpful tool for data update/delete/insert load.

But at the same time, I understand it is not so flexible to add other...

Thanks, Jeff,

the query works perfect, I was not sure how to calculate the value by using a counter, now I learn from you that I can use row number...

well, the script is to update a column A based on a column B in the same table.

If column B value is null, then use A will be concatenate with...

sekalps (1/5/2012)

---

Hi sqlfriends,

1. If the NULLs are denoted by empty values, then set the "Retain NULL values setting" by checking on the check box in the Flat File source in...

Thank you very much, this is very helpful.

Koen Verbeeck (12/16/2011)

---

There are multiple options:

* you can use the MERGE JOIN to join the two datasets together. The input needs to be sorted, so if your flat file has...

Thanks all for the ideas.

The reason I use cast the birthdate is because the birthdate column is varchar in a staging table.

The staging table comes from a ssis package load...

Thanks,

My table A has 400000 row counts, but the table B only has 100 row counts.

So I think if I should do a join of two tables to insert, or...