OK, one more question. The query I ran shows the last processed date if you right click on the cube database properties on SSAS, which is not the same date...

Raunak,

This is perfect! I see all of the...

No problem, Mohamed! I appreciate your help. I did find out that the developer was running it in 32 bit mode, which is important. I think using a variable will...

Ok, found more info. The developer did create the package in 32bit mode, which I'm having him investigate to tell me why he did that. But I just ran the...

Since I'm running this from a SQL job, I think that SQL will automatically run it in 64bit mode. When we install SQL we always choose 64bits so I think...

I'm confused. Why would I want to force it to use 32bits?

Good idea, but same results. I overwrote the config file and only exported the name and the password of the SQL login. I think I'm going to have to look...

I've included the relevant part of the config file that deals with the Crook connection manager. I've replaced sensitive values with descriptive names.

<?xml version="1.0"?>

<DTSConfiguration>

<DTSConfigurationHeading>

<DTSConfigurationFileInfo...

Mohamed IDTTALBE (7/13/2015)

---

In fact I always use the command line dtexec instead of scheduling in sql server

First do u use a 32bits computer to make your development and a...

Mohamed IDTTALBE (7/11/2015)

---

Hi

First you have enter development of the package again

Then choose DontSaveSensitive

Configure a new configuration file for the package and edit it to save login and password

Edit again the...

One more thing I tried - in the Command line tab in the SQL Agent job, I edited the command line to include the SQL login account and password. Didn't...

Ah, that's it. I'm having trouble getting the syntax right for this. I created a temp table for the catalog names and then tried to get the last processed date.

CREATE...

I didn't mention that in SSAS I have 21 cube databases. Each cube database has 1 cube associated with it. I don't know if that makes a difference.

Alvin,

Thanks, I've created the linked server. When I run that query in master on the DB instance I still just get one row for one cube instead of 21 rows...

Lowell,

I think this is really close to what I need. I created the linked server, which is helpful. The result of the second query is the information I need but...