Ok I figured it out. I took some thinking through it.

If "Fail the transformation if it detects changes in fixed attributes" is selected as it is below, then the whole...

Everything seems to be fine Igor. I just needed to start the service.

I was getting this error because the service wasn't started. I went to Administrative Tools Services and I made sure the services were started. Even though it as set to...

Thanks 3 BILLION! That worked!!! I had to add another slash in there.

string ConnectionString = "Data Source=Localhost\\Arius;Initial Catalog=Northwind;Integrated Security=True";

I do wonder why this wasn't needed before.

Thanks very much for your replies. I'll answer as best as I can because I'm an novice.

mister.magoo (11/3/2013)

---

So, this is a web application running on the same machine (MIKE) as...

larskandersen, I can't thank you enough for the information.

kl25, thanks for the book reference. I'll certainly check it out.

IF it is not too much can you tell me what was the clue to your realizing that i was trying to do too much with that data mart? I...

Thanks again for the very valuable information larskandersen!!! I did not see the notification that you had replied.

Thanks very, very much. I'm going to apply your suggestions. I went...

Thanks very much for the information. It sounds very good. It seems like a breath of fresh air. I'm new to this and I'm trying to think it over.

So...

Ok after going through all those steps, I went through all these steps found here. They were already set correctly which was good and encouraging. But that also met the...

At first it was telling me that osql didn't have good features. So just in case I thought I'd shorten the path and put the file in c:

Here is...

i appreciate the info

Thanks Hanshi

HanShi, Thanks! You are worth a million!!!!

What i did was look a little more closely and saw that there was a SQL Server (MSSQLSERVER) that as not started and...

HanShi (8/28/2013)

---

Start "services.msc" on the host server and check if all needed SQL services are started.

- SQL Server

- SQL Server Agent Can not be started with SQL Express

- SQL Server...