Click on the Excel connection manager. In the properties, locate the connectionstring property. There, change HDR=YES to HDR=NO.

What locale does your server use? (SQL Server as well as the physical server itself)

Create a package using the import/export wizard, do not run it but save it.

Then open it with BIDS and modify it as you want it to be.

kramaswamy (11/8/2011)

---

In the second tab, join the column from your data source to the LookupID in the Lookup table.

Then, go to the Error Manager, and change the error handler to...

Steve Jones - SSC Editor (11/8/2011)

---

I'm sure you'll pass me. I am down to about 150 posts a month, too busy with other stuff and most questions are being...

L' Eomot Inversé (11/8/2011)

---

The next bad normalisation myth is that normalisation always increases the amount of storage required - a database in 3NF will require more storage than the same...

To expand further:

if you use the MERGE JOIN, you need to sort on the join keys first, using the SORT component.

If memory or performance is an issue, consider staging the...

What is the question here? Do you have a specific problem somewhere where you need assistance?

Or do you just want someone to make the entire solution for you?

ps: take a...

How many characters has the word Other?

How many characters has your destination column?

Et voila, there is the solution 😀

:w00t: How dare you!

Roy Ernest (11/8/2011)

---

I am planning on a presentation for my user group "DBA MythBusters" (Courtesy...

philip.cullingworth (11/8/2011)

---

WORD OF WARNING,

Having guessed the right answer I then decided to run it on our SQL 2005 (production) server.

After restarting the service this line was found in the log.

11/08/2011...

SQLRNNR (11/8/2011)

---

Maybe it...

sris84 19444 (11/8/2011)

---

4. How often did you DELETE/ UPDATE your FACT tables?I said I never delete from fact I only insert in fact tables they are not satisfied...

Ans : When...

Here's a screenshot (in attachment).

I ran it in SQL Server 2008R2, and I got the severe error.

The plot thickens... 🙂