Strange. You should be able to use the service account impersonation setting. It's what we use here at the current project.

Make sure the SSAS service account has read permissions on...

The OLE DB connection manager doesn't just dissapear when you deploy the package to the server.

If you open up the source component, do you see the connection managers name?

To check...

paul.knibbs (3/26/2014)

---

Seems I should clarify: I said it wasn't a totally unreasonable position, not that it was a position I agreed with. Wanting cross-compatibility between different database platforms is something...

Are any of the Hekaton/columnstore features part of the ANSI standard?

It would seem...

There seem to be 2 issues:

* an ole db connection manager is not found. It surprises me that this error is not present in BIDS.

* the file "L:\Information Technology\Business Intelligence\BI...

In simple: DQS is for cleaning data, MDS is for storing the master data.

They can be used together, but they can also operate alone just fine.

Master Data is typically what...

You can use CONVERT for that.

DECLARE @TestDatetime DATETIME = GETDATE();

DECLARE @TestDate DATE;

DECLARE @TestTime TIME;

SELECT @TestDate = CONVERT(DATE,@TestDatetime);

SELECT @TestTime = CONVERT(TIME,@TestDatetime);

PRINT @TestDate;

PRINT @TestTime;

If you want the values inserted in seperate columns,...

Phil Parkin (3/26/2014)

---

1) As Aaron has already pointed out, Excel doesn't do data-typing. Regardless of how Excel displays data, it is either text or numeric. Dates (I think) are stored...

Great question, thanks.

Nice question, thanks.

dan-572483 (3/25/2014)

---

The Excel file contains data going back several years and I'm only looking for data entered in the past few weeks. (Honestly it is a personal...

That's something completely different from your first question.

If you named the column ABCD1234,...

Paul Williams (3/24/2014)

---

From a modelling perspective from what you have said, I would say your best bet is to create a Junk Dimension or Junk Dimensions depending upon the data...

SELECT student_id, cnt = COUNT(subject_id)

FROM #student_details

GROUP BY student_id

HAVING COUNT(subject_id) > 1;

Since this is most likely a homework assignment of some sorts, make sure you at least understand the solution given.

Good that it works,...