Paul Monaghan (7/23/2010)

---

Also, is it worth adding all details I have on the customer to the Customer dimension(i.e. customer address)? They haven't asked for it, but I'm betting they do,...

Nope, there isn't such a thing in SSIS. SSIS is awful when it comes to handling metadata changes.

However, it can be possible that there are commercial components who can do...

Jeff Moden (7/16/2010)

---

da-zero (7/14/2010)

---

:blink:

I think I have an URL where you can download experience. If I...

Then add a derived column in your data flow that converts the emptry strings to null values.

You need an expression that resembles this:

[myColumn] == "" ? NULL(DT_WSTR, 10) : [myColumn]

This...

Vernon Jimmerson-306463 (7/14/2010)

---

SSIS is a maintenance nightmare! Avoid SSIS like the plague. It's for people who shouldn't be coding at all! About the only exception I can think of is...

How do you define empty cells? As an empty string: "" ?

In your Excel source, go to the advanced properties and check the datatype of your output column "Comments".

Chances are that is has a datatype with a lenght shorter then 4000,...

I believe that the SSIS service on your local workstation is necessary so that you can run packages in BIDS.

However, if you run the package in SQL Server itself, it...

For those too lazy to copy-paste:

http://support.microsoft.com/kb/918760

And you're right, that is usually the problem: permissions.

Isn't an empty cell without a value equal to NULL?

samalex (7/15/2010)

---

Michael.. I found a 'solution' that's working, but it may be worth setting-up a processing server just for such jobs since the solution isn't ideal.

My work around was to...

I know we didn't answer your question. 🙂

But I would be interested in reading such an article.

Maybe you can try to send a reminder, or to contact the editor of...

:blink: You stole my idea! 😛

I have an easy solution for that problem:

use Excel 2007 or later 😉

Are there any other jobs running on production?