Check out - http://www.microsoft.com/office/dataanalyzer/default.asp

Should be lots of good info there to get you started.

hth,

Michael

Michael Weiss

That is exactly what I was thinking, Steve. How does the swap file/paging file size enter into this? Do you know?

I will do as you suggest and let you know...

Thank you for the insight! Never would have thought to look at the registry settings. However, since you mentioned it, I did check the HighMemoryLimit key on my AS server...

Hey Ryan,

You are correct...if you add records to the table(s) underlying the cube, those records will not be reflected in the cube until you either perform an incremental or a...

Look in Enterprise Manager under Management ->SQL Server Agent -> Jobs...your scheduled job should be listed there.

hth,

Michael

Michael Weiss

In Analysis Services Manager, click on your cube, choose Edit and set the Source Table Filter property...that should do it!

hth,

Michael

Michael Weiss

One way to do this would be to place an ActiveX task after your ExecuteSQL task. In your ActiveX task, check the value of your global variable...if it is an...

You could configure an output parameter in your stored procedure - see (watch for wrap of url):

http://www.sqlservercentral.com/columnists/sburke/introductiontostoredprocedures.asp

Then create a global variable in your package. In your Execute SQL...

Hi Cheryl,

Here is the url for the article...hope this does the trick for you. Let us know if you deploy it and how it works, okay?

http://www.sqldts.com/default.aspx?6,101,226,0,1

Regards,

Michael

Michael Weiss

You can do it via an ActiveX task and global variables. Also, check out sqldts.com for an article there on how to do this with a common dialog box.

hth,

Michael

Michael Weiss

Have you tried reinstalling pts(lite) on the client? Also, have you thought about installing SP3 for AS?

Michael Weiss

Check out this link...

http://www.sqldts.com/default.aspx?6,222,227,0,1

hth,

Michael

Michael Weiss

Have you been to sqldts.com? Check out this article - maybe it will help.

http://www.sqldts.com/default.aspx?6,222,267,0,1

- or -

http://www.sqldts.com/default.aspx?6,104,207,7,1

hth,

Michael

Michael Weiss

Not as far as I know...the ActiveX task should execute. If it isn't, you should check the permissions of the user under which the task or package is being executed.

hth,

Michael

Michael...

Does the user account under which the package is being executed have rights to access the folder in which the file resides? This sounds like a permissions problem. If the...