DTS Not Getting Refreshed
Apr 18, 2008
Hi All,
I have created a DTS package to export daily load to ftp folder. It has couple of sql tasks, global variable to hold the sql result set and vb script to read results from global variables, create files to upload them to ftp folder. The DTS running to success and uploading files with latest data to ftp when I run it manually. But, when I schedule it, it€™s not picking the latest data from the database. It€™s uploading files with old data (the data it picked up was the data it picked when I scheduled it for the first time). I think the result set is being cached somewhere. But the €˜Turn on Cache€™ property is unchecked.
Is there any settings we have to do while scheduling the job?
Thanks,
Muthu
View 1 Replies
Sep 5, 2007
I have setup Transactional replication in SQL 2005 between two servers and have about 200 tables being replicated. The problem is that every time, I add or drop a table to replication, and start the Snapshot agent, it re-initializes every article and re-loads every article. This process takes 1 hour to complete and CPU usage goes to 100% during that time.
This behaviour seems very different from SQL 2000 where I would start Snapshot agent and only the relevant tables were added/dropped.
Has that functionality changed from 2000 to 2005? Am I not doing something right?
Thanks,
Amir
View 3 Replies
View Related
Jun 18, 2015
My boss and I attended the SQL conference in Vegas a few years ago. He remembers a session on tabular where the presenter said when the underlying table that tabular is built on changes, it automatically refreshes the tabular db. Now that we're working on a tabular project I'm looking around for this information and don't find anything like that happens. From what I can see, the refresh either has to be scheduled from a task, or manually refreshed by right-clicking the db and selecting "process db". He said the session presenter was a Microsoft Program Manager too. Is there any truth to what he remembers?Â
View 2 Replies
View Related
Mar 27, 2008
I'm relatively new to Report Designer in VS 2005 and have been trying to get a parameterised report working.
I have an MDX query that works with the datasource I set up, but as soon as I try to add a parameter, the fields disappear from the dataset.
Here's the query:
Code Snippet
SELECT
NON EMPTY { [Measures].[Var Rc] }
ON COLUMNS,
NON EMPTY { ([Time].[Year - Quarter - Month - Date].[Date].ALLMEMBERS *
[Company Master].[Region].[Region].ALLMEMBERS ) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME
ON ROWS
FROM
( SELECT ( Filter( [Company Master].[Region].[All].Children,
Instr( [Company Master].[Region].Currentmember.Properties( 'Member_Caption' ), @RegionParam ) > 0) )
ON COLUMNS FROM [Supplier Spend])
CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
This is all a generated query apart from the filter. If I change the @RegionParam back to its old constant value (which was 'Europe') then the fields appear again. I've set up the Query Parameters to cope with @RegionParam and also put a Report Parameter in the Layout page that uses it.
I'm lost as to why the fields don't appear with the parameter in there...
Rob
View 2 Replies
View Related
Apr 23, 2015
I have set the slicers on paritions using Script task.
After cube process, the mdx queries are not hitting partitions as per Slicers.
But once i open each partition slicers from SSMS and close it by doing ok. My mdx query is good enough to hit the relative partition only.
But it is not possible to manually refresh each slicer on partition.
Is there any way out to solve this issue. I am using 2008 R2.
View 2 Replies
View Related
