Merry christmas!

In Belgium, turkey is traditional christmas dinner, but I guessed the correct answer 🙂

Happy holidays!

Lamprey13 (12/22/2011)

---

I'm not trying to say anything about you or your knowledge about data warehousing, but there are a lot of popular data warehousing techniques that are plain wrong. Denormalizing...

Andrew Watson-478275 (12/22/2011)

---

That's the second or third R2 limits question we've had - I've now got that page on favourites, ready for the next one ;-).

I always find some of...

There's a whitepaper from the SQL Server team.

Also check out this article:

http://blogs.msdn.com/b/john_daskalakis/archive/2010/01/07/9945117.aspx

For DTS:

http://www.simple-talk.com/sql/ssis/dts-to-ssis-migration/

How painless and smooth it will be, that depends on your system 🙂

What happens if you set it to False? Does your package work?

But if a person doesn't have an education, you still have a NULL reference?

dilipd006...

According to Wikipedia:

"ad hoc" reporting systems...

srik.kotte (12/21/2011)

---

Hello,

I have an issue with execute sql task. I have 2 variables in execute sql task.Count and filename.In the sql statement I have given like this

INSERT INTO dbo.esg_account_audit(operation,num_records,file_name)

Values( 'Account...

If the table doesn't exist in the source, why is there a source component...

The unnecessary space by NULL values can be avoided if you use sparse columns.

http://msdn.microsoft.com/en-us/library/cc280604.aspx.

If you use design #1, you also have to add a new column in the transaction tables...

Why is the EndDate column used for all the values of AssetSK?

Test4 is a new business key, so why should EndDate of other business keys be adjusted? This is not...

pallavi.unde (12/22/2011)

---

I imported one table on other server it done successfully.

but now if i tried to import whole database on other server it's showing error :-

Messages

Error 0xc0202009: Source 322 -...

Dev (12/22/2011)

---

Koen Verbeeck (12/22/2011)

---

Dev (12/22/2011)

---

Nice analogy 😉 but why consider fixed / standard drawer only. Why not considering a drawer that allows us to adjust the...

Please explain a bit more what you are trying to...