Instead of using Success can you change the arrow to complete, check for a newly downloaded file at the next step, and proceed from there?

I can tell you what I was thinking you might do, but if it doesn't work it doesn't work.

Given your restrictions, one way I might try to crack this is...

Sorry, I don't. I had thought that you could try to create a view and then add that to the data view, but I don't know how you get...

As someone has pointed out, if you're using a straight Gregorian, there's little you can do. You could break each month down to five weeks, 1-7, 7-14 etc, with...

I don't know why you don't combine the tables. They seem to have the same level of granularity, which is the key factor in determining the structure of your...

Being a BI team of 1 isn't that unusual, but it sounds as if you didn't transition slowly into that role.

Although there are plenty of tools, both SSAS and ProClarity...

I would recommend as a MINIMUM that all the stored procs you create be abbreviated usp_ for "user stored procedure." Not only does that avoid the sp_ issue but...

The above steps are good, but I would modify as follows:

1. Don't worry about data mining for the moment.

2. When you focus on what you want to measure,...

I think you're being too sensitive. I don't refer to my doctor as a general practitioner, and I call specialists doctors. I imagine that within the field, they...

I'm glad it finally worked for you.

I found security much easier in Analysis Service 2K, although I still think AS2005 is overall better. Unfortunately there is no...

Try changing full control to read definition and see if the tabs become available.

In the solutions explorer, go to the Roles folder. Create a role with the appropriate permissions and users. In the cell data tab of that role, click "Test...

Have you set the permissions in BIDS? If so, did you do a test deploy? It doesn't seem like a required step, but I got hung up in...

if you were adding information, you could use partitions. Are you already doing this to pick up the new records? If not, don't you have to process anyway....

I can't understand why you wouldn't want to update the fact table. You are already updating it with the entry of a new record, so why not have a...