Problem Developing OLAP cubes have always been fascinating to me. Right after completing the development of a data warehouse, my next line of action often becomes setting up Analysis Services for the warehouse. Although, there are multiple client tools readily available in the market to perform some analysis on this SSAS Server, sometimes it is […]
2019-12-31
5,917 reads
2018-10-11
13,432 reads
Hi ALL,I have a published a few Reports with drill down features and the reports work fine. The only thing is that the Data is large and it takes a while to process the data even to use the drill down feature.Am opting to use 60 minutes cached report. The first run works well but […]
2005-05-01
772 reads
I think I recall reading somwhere that GetExecutionErrorInfo doesn't work within the package. You'll need to wrap it in a DLL to get it to work.Personally, I have package logging enabled for all the packages and then I have a stored procedure that extracts the error text from the sysdtssteplog table.
2005-05-01
MikeYes you could do that, but as you've already pointed out, parallel execution brings it undone What would have been really nice was a method of referencing the current step in the same way that DTSGlobalVariables.Parent references the current package.
2005-05-01
Perfect Frank, its exactly what I need.Thanks again.CCB
2005-04-27
Are you ready to take your SQL skills from theoretical to tactical? If you've...
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers