Congrats!

Nevyn (5/13/2014)

---

Steve Jones - SSC Editor (5/13/2014)

---

That's interesting. however, do we want the first or last year? When I started in CS, the first year was hard, really hard with...

Thomas Abraham (5/13/2014)

---

Gary Varga (5/13/2014)

---

I think that the problem is twofold:

1) Graduates with Computer Science degrees have little understanding of applying what they have been taught in the real world.

2)...

How many rows do you expect?

It doesn't matter if the connection that creates the temp tables is disconnected before any other...

Any resource on that?

david.irvine 7489 (5/13/2014)

---

Koen Verbeeck (5/5/2014)

---

Hany Helmy (5/3/2014)

---

Thomas Abraham (5/2/2014)

---

paul.knibbs (5/2/2014)

---

Is it? I can't recall a situation where I've actually used this...

Google won't kill you.

Anyway:

Developing with Analysis Management Objects (AMO)

An example:

Managing SQL Analysis Service Objects with SSIS and AMO[/url]

Regarding package configurations:

SSAS Connection String Dynamically[/url]

What you could do is create a child...

After some googling it seems indeed SSIS has an issue with dynamic SSAS connection (how stupid).

The alternatives are using AMO in a script task or using package configurations.

Can you post an example of such a connection string?

If you would copy paste them yourself in the connection manager and you run the package, does it work?

Can you post the exact error?

Stewart "Arturius" Campbell (5/13/2014)

---

I replaced the old IBM Doc Store application using FileTable.

About...

Gary Varga (5/13/2014)

---

Koen Verbeeck (5/13/2014)

---

I have a degree in computer science. For about 95%, it did not learn me anything practical that I still use today.

The basics of SQL of...

You should be able to view the SQL statement in profiler. Or at least find a stored procedure.

SELECT MeterID, ReadingDay = CONVERT(DATE,ReadingDate), ReadingHour = HOUR(ReadingDate), SUM(Reading)

FROM

(

SELECT r.MeterId, r.ReadingDate, r.Reading

FROM MeterReading r, MeterDetail d, Building b

where r.MeterId = d.MeterId

and d.BuildingId = b.BuildingId

and b.BuildingName like '%182%'

and r.ReadingDate between '2014-01-01'and...