Search results for query: *

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...

...cause. It might an oracle view to get the result set. Don't trust just on that you can nicely open the query with some Winsql. Try SELECT COUNT(*) FROM (your query) DERIVED. Do you have two processors? Enable multi-procs in Transformers data source and see if that helps (probably not much)...

...Works with years greater than 1899, though it's quite easy to change it to make it work with older years too: SELECT myISOweekyear, myISOweek, 7*(myISOweek-1) + DATEADD(yy,myISOweekyear-DATEPART(yy,0),0)+ 3 - DATEDIFF(dd,0,DATEADD(yy,myISOweekyear-DATEPART(yy,0),0)+3)%7 AS Monday_datetime...

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...

Do you have some metadata / data lineage features in yuor package, or is this a "normal, plain" package ? Cheers Backup system is as good as the latest recovery

What system produced that log ? Cheers Backup system is as good as the latest recovery

Use search for this forum, I've seen this topic many times. Sorry I'm too tired to give you any other advice. Cheers Backup system is as good as the latest recovery

So, never be afraid to start from scratch. What still puzzles me is the question word being the main question word in the Mika Waltari's novel Sinuhe, the Egyptian... Another star to gradley for spelling out BOL, I'm mostly too tired to do that. Cheers Backup system is as good as the...

Well you always have the total amount in dimension level by design, so the users are able to figure out how much the other depts combined measure amount is (total-dept01). There is no way around this, cubes overall sum is alwayd the same, no matter what categories are visible or not. You could...