Yes. It is...

DerbyNeal (7/11/2011)

---

AAAARGH... This is so frustrating.

I think I have supplied sufficient details in my related posts.

I can't use the 'sa' account. The sa account doesn't have the rights to the...

sowmya.boodaderureddappa (7/11/2011)

---

Hi Koen

I am able to open them individually in designer mode and run, but when i run the main package ususally the chidl package opens up and shows the...

Phil Parkin (7/11/2011)

---

The fact that the data shows up OK in the data viewer suggests to me that this is not a classic Excel-datatype issue, because it seems that the...

No, not in an event handler. The pre-execute event handler is fired more than once and it doesn't control the control flow.

Follow the steps as I described earlier:

Place your entire...

LutzM (7/9/2011)

---

If I would have to stop on a highway (or Autobahn as we call it over here) other than because of a traffic jam, I'd immediately run and jump...

Nah, Belgian style is more like...

There are a lot of members who created an account, asked their question, got it solved and never got back.

But at least it means that 1,400,000 people know about SSC!...

Elliott Whitlow (7/7/2011)

---

BIDS will do the upgrade (generally) but you need all of the packages in the file system, thats the only place they can be edited. As far...

JustMarie (7/7/2011)

---

Mind you - I'm not one of the gurus on here. Hopefully someone will correct me if I get things wrong.

To use variables in your SQL you need...

Christian Allaire (7/7/2011)

---

Hi,

I am struggling with loading Excel files in SSIS. If a colums contains mixed alpha and numeric characters it gets changed to null. Here is my...

Isn't there a way to rewrite the query so that a cursor isn't necessary?

You can use the For Loop and the For Each Loop in SSIS to create loops.

I never use the SCD component. Ever. And never will.

By the time I have set-up the component, I've made a similar set-up in TSQL or with other SSIS components. That...

Sure.

In the Excel connection manager, change HDR=YES to HDR=NO. This means that the Exel file won't have a header row, so you read the first line as normal data. Use...

Data warehouse concept:

http://en.wikipedia.org/wiki/Data_warehouse

The most simple (and of course oversimplified) defination I can think of:

"a data warehouse is a database with a time aspect"

The time aspect means that if a record...