aarionsql (4/17/2012)

---

Having looked at it a bit more the issue seems to be any new columns added to the Derived Component is not being added to the Data-Path of the...

Right-click on SQL Server Agent and select properties.

Go to the Alert System tab. Check if the Enable Mail Profile checkbox is selected and that the correct mail profile is chosen.

irridessa (4/17/2012)

---

i am just learning how to use SQL Server 2008. i messed up and i want to delete everything i did and start over. how can i do...

It's up to you.

You can upgrade your SQL Server 2008 instance to 2008R2, or you can install a new 2008R2 named instance.

Is this locally on your computer or in a...

There is another one scheduled for the end of the month.

I'll try to think of more SSIS 2012 questions 🙂

Since this is a repost from an editorial written in 2007 - 5 years ago - what is your current viewpoint?

A lot of things surely have changed: a shift to...

imani_technology (4/17/2012)

---

This is good news! How about if I want to user to pivot using something web based? Can I put an SSAS cube on SSRS using the...

It says

The table below lists the supported upgrade...

This should get you started:

Querying SQL Server Agent Job Information[/url]

Hold on to yourself, because it's a SSIS 2012 question tomorrow 😀

Great, glad that you got it working.

edvard 19773 (4/17/2012)

---

First - This question was misplaced.

Its repeated in a better place (Forum), where i got a proper answer.

But, I really want to be able to run through a...

opc.three (4/13/2012)

---

Did you install Developer Edition named instance or just quit after seeing SSIS-state during the installation process?

If you can play, I would try installing the Dev instance and see...

UPDATE r

SET employeegroupid = tmp.employeegroupid

FROM

dbo.rollingdutyrostershift r

INNER JOIN

(

SELECT DISTINCT employeeid, employeegroupid

FROM...

Make sure you export the data as unicode.