Recent content by yksvaan

Same thing happened here with PPES 7.1. We had an scheluded self-build script that was stopping and restarting service. We quit using that and it seem to help. But I still suspect the real reason was the defragmentation software running in backgroung all times. I think the software was...

I've noticed this too. If the expression on the left of -- can be implicitily converted as a number, or is a number (see below), TD might interpret -- as "minus unaryminus expression", which is of course same as plus. SELECT 8+12 --4 This problem can be avoided by having always an extra...

You probably need IMEX setting, see JayKusch's solution on thread961-603986 Same issue covered in http://www.sqldts.com/default.aspx?254 Cheers Backup system is as good as the latest recovery

If you have IIS running on sql server machine, you can easily send self-formatted SMTP mail messages within ActiveX task (search forum), so no Exchange configuration circus. Some settings might be needed on IIS to make it work, but normally it works out-of-the-box, of course some settings on DNS...

Last period will work, but in the Time-tab on the levels of the time dimension you must uncheck "Generate all categories in the period" (and clear your present time categories you might have in the model). Then you won't have the Friday in your cube at all if you don't have any data for it. And...

I think it also depends on hardware setup (and on manufacturer), it might be that on the same machine raid1 wouldn't be significantly better. But your 73 mins, as other members stated, is the overall time that oracle answers, gets the result set, sends it over network and Transformer saves the...

If you were using European week standard (International Organization for Standardization), and your year states the "year of the week" instead of calendar year, you can get Monday with the following, no matter what DATEFIRST setting you have, there's example data. Works with years greater than...

Why ? Cheers :) Backup system is as good as the latest recovery

SQL/DTS documentation Books Online (BOL) that comes with Enterprise Manager, and is also online at microsoft.com Cheers Backup system is as good as the latest recovery

I thougt you got it that I was exaggurating a little :) However 100-300 Meg cubes are not that rare. I understand and couldn't agree more that OLAP is not made for several dimensions heving ten-thousands of lowest-level categories. But what can you do, when the customers want to buy such...

First, you should have a summary table/view in the database in that case that your big table is of transactional nature and/or itself is not summed up to the lowest-level of the dimensions. I know it might not be "easy" to have dba to provide such a summary table, but at least ask for a view...

And besides SqlTask I think you also can put EXEC proc as source sql, so you get the result set data to be transformed to destination. Cheers Backup system is as good as the latest recovery

Can't say about your code but if it's a syntax issue the following example works (it is not a transformation), maybe you get some help out of it. Of course, you need VBScript.RegExp library on our computer. Function RegExpTest(patrn, strng) Dim regEx, Match, Matches ' Create variable...

Make an empty text file, rename it as .udl and open it. Later you can manually edit .udl with text editor. Cheers Backup system is as good as the latest recovery

It is possible to relay information with Global variables, and change the source / dest databases with Dynamic Properties Task. But there is no easy way, you have to modify you packages quite a lot and know what you are doing. How about saving packages as vb files, search/replace database names...