Excel is great up to a point, but if you need a dashboard/EIS or you need to schedule reports and distribute them, try Brio (now called Hyperion Intelligence), Business Objects....

Even simpler - take Nicholas' suggestion (sp_start_job) and insert it into your scheduled job, ie, NOT your DTS package. You will then have a step dependency. Your first job needs to...

Monsieur Vincent

We use Netbackup too, but avoid your problem by using a scheduled SQL Backup to disk on the server, and allowing Netbackup to simply do disk backups from there.

I...

Did you do a "Full" process or just an "Incremental" on the dimension? If your deleted data was key to a hierarchy you will have changed the structure so a...

Using the SQL techniques described by the other guys, you need to create a table containing a day_id,week_id,month_id and year_id (maybe even a Quarter_ID?), so that every day has a...

Unfortunately you need System Admin rights to run cmdExec jobs. MS introduced this to block a security flaw allowing a back-door entry to databases.

HTH

Steve Vincent

I agree with Steven, but in addition, you might try running the package with a parameter string from the job scheduler. Eg.

DTSRun /S "MyInputServer" /N "MyDynamicPackage" /A "MyDbGVar":"8"="MyDb" /A "MyOputServerGVar":"8"="MyOPServer"...

Thanks Steve, I'll give it a try

Cheers

Steve

Hi Ray,

Does your product need to extract its data from either Oracle or SQL DBs? Or do you supply the data yourselves? You should forget about building cubes in Oracle...

Hi Ray,

We use Brio to access our cubes, but there are many other front-end apps. They all generate MDX basically. We pull data from an Oracle warehouse into a SQL...

The easiest thing to do is accept the default of migrating to MSDB. It's reasonable to store the repository here, since it will sit alongside the DTS packages and scheduled...

Those settings sound a bit strange Michael. If your server has only 2Gb, surely the HighMemoryLimit must be set lower than that (you need to reserve some RAM for the...

Dear all, my problem is fixed thanks to a very helpful Microsoft software engineer. There is a registry key (HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP Server\CurrentVersion\HighMemoryLimit) which in my case had a default setting of...

quote:

---

Using client network utility create an alias for your SQL Server instances, I have seen this when I was working in beta...

SP3 installs MDAC 2.7 so I guess what you're suggesting is rolling back to 2.6. I will certainly give it a try - nothing to lose!