10e5x (12/10/2012)

---

Ok Jeff I got it. So I can't use your method? Even if I create those task? So sad, so wasted anyway thanks for the help.

Btw if I...

Yes and No. I'd probably move Vendor over to the Fact table but stay with the same general pattern....

MikeBrey (12/7/2012)

---

These surveys run for only two weeks twice a year and sometimes for the same vendors. The employee response date they are not too concerned about. Wouldn't you be...

Jeff Moden (12/7/2012)

---

{edit} I see Craig already covered the backup recommendation. I didn't look any further down when I saw the message. All I saw was "Oh...

That looks about right to me, however I'd have the survey itself linked off as a snowflake for survey/question dimensions (so I could pull up the actual question for reports...

ryetimothy (12/7/2012)

---

So I ran the test code and it worked. I'm guessing my next step is to try it on a section of the real table, but I had...

You have different security rights to the DB2 components then the SQL Agent does. You need to find out what login the Agent is running under and change its...

DZN61 (12/7/2012)

---

I have 5 tables

Reports : which contains the name of the reports

Cars : which contains the name of the cars

Parts : which contains the name of parts

CarsAndParts : which...

Well, without the DDL for the tables it's hard to answer your question directly. I'm having a real hard time following what your question actually is, unfortunately. That's...

Silly question, but what is SSDT? Is that something new in SQL 2012?

I personally have always saved to filesystem first so we can sourcesafe the packages, or at the...

Okay, so we're back to the original idea of what we were looking to do. However, before you trust this code, make sure that you check the results of...

Evil Kraig F (12/6/2012)

---

Brandie Tarvin (12/6/2012)

---

Hey, all. I don't know if I posted this before or not. If you're interested in writing, I have a special call that opens in...

ryetimothy (12/7/2012)

---

Here's the CREATE TABLE script for the full table, the consumable data is below. I had to exclude some of the variables due to length restrictions for QUOTENAME...

ryetimothy (12/6/2012)

---

Thanks for the reply! Each record has a datetime stamp, but for some reason they're not consistent, meaning that some duplicated records have the same datetime stamp, but some...

Brandie Tarvin (12/6/2012)

---

Hey, all. I don't know if I posted this before or not. If you're interested in writing, I have a special call that opens in February for science...