Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Motlatjo
  • Content: Threads
  • Order by date
  1. Motlatjo

    All Dimensions showing on Excel, but only 3 showing on SSMS

    Hi My issue is after deploying my cube, all the dimensions are visible on Excel, but only 3 are showing on SSMS I want all of them to show on both Please help Regards
  2. Motlatjo

    What is the best way of processing millions of records into FACTS and Dimension?

    Hi I am creating a data warehouse that is sourcing millions of records. I am using Slow Changing dimension and TSQL views to process the Dimensions and FACTs Now performance is very bad How can i make it better? Thank you in advance
  3. Motlatjo

    SQL Server Data Warehousing Best Star Schema Design Practices

    Hi Can you please recommend a site where i can be able to learn more about the underlying topic Thank you
  4. Motlatjo

    SQL Server Agent and SSIS 2014 job failure

    Hi I have an issue with scheduling a job. The job is supposed to execute SSIS package deployed on Integration Service Catalogs. Then the job return an error message, “Task_Name: Error: There were errors during task validation.” on all the tasks. Can somebody please tell me what I am doing...
  5. Motlatjo

    Integration Services Catalogs

    Hi all After i have deployed my packages on SSIS 2012 Project Deployment model, are they still connected to the ones on file system? Thanks
  6. Motlatjo

    Report Manager VS. Visual Studio

    Hi I have a report in Report Manager that renders faster, then i downloaded the .rdl file, but when i test it in Development Studio, it is very slow, what might be causing this, how do i fix it? Thank you
  7. Motlatjo

    Background Image not showing when exporting to Word

    Hi I have a report that have a background image in a rectangle When I export to PDF works fine , but when I export to Word the background images are not showing. Is there a solution for this problem? Thanks
  8. Motlatjo

    Script Database with T-SQL

    Hi I want to have a Stored Procedure that will script my Databases, i do not want to back up data, only to script database through T-SQL Thank you Motlatjo
  9. Motlatjo

    Query Performance very slow

    Hi I have this query that works fine when tested against Pre-Production data, but when i took it to Production it took forever to execute below is the query --Start DECLARE @Agent VARCHAR(25), @Queue VARCHAR(10), @Status VARCHAR(15), @Reason VARCHAR(25), @Time DATETIME, @Date DATE...
  10. Motlatjo

    'Internal error: An expression services limit has been reached. Please look for potentially complex

    Hi When i execute my report, i get an error, 'Internal error: An expression services limit has been reached. Please look for potentially complex expressions in your query, and try to simplify them.' below is the query, Please help me simplify SELECT Date, SUM(Four)...
  11. Motlatjo

    Hide Report viewer toolbar

    Hi How do i hide report viewer toolbars? Thank you
  12. Motlatjo

    Conversion failed when converting date and/or time from character to string

    Hi Guys The query below works fine in MSS Management Studio, but when i try to run this query on the report, it returns "Conversion failed when converting date and/or time from character to string" All the date fields used here are of DateTime datatype Please help Thank you in advance...
  13. Motlatjo

    Report link returns an error

    Hi After subscribing a report, it returns a link to access the report, but when i try to use the link, it returns the following error: The report server encountered an unhandled exception in HttpApplication. (rsUnhandledHttpApplicationError) Get Online Help For more information about this...
  14. Motlatjo

    Report hangs

    Hi I have got a query that take 0:01:28 to execute in SSMS when i select data for a month, but in the SSRS report takes forever for a month. Please help Thanks
  15. Motlatjo

    Report hanging when i preview

    Hi I have got a report that has 5 parameters, DateFrom, DateTo, HourFrom, HourTo, StudentName(which select one or many). This report returns data only when i select 1 day on the date parameter. The issue is, when i select data for 7 days(week) or more, the reports keep loading until it displays...
  16. Motlatjo

    Table-valued Functions

    Hi All I have this Table: Name: One ID Name Status Reason StartTime 1 Chris Busy Personal 2013-02-22 06:20:23.100 2 Chris Busy Case Related 2013-02-22 06:21:44.100 3 Chris Busy Lunch 2013-02-22 06:22:56.100 4 Chris Busy Available 2013-02-22 07:22:10.100 5 Mantsha Busy Personal...
  17. Motlatjo

    Hi All, I have many Data Flow Ta

    Hi All, I have many Data Flow Tasks that are running sequentially, i need to know if there is a way that i can make them run concurrently(Same time) Thank you
  18. Motlatjo

    While loop skeeping records

    Hi all I have a table with two records, and i want to manipulate one of the columns. here are the records Name DateCreated TotalTime(ms) Chris 2013-01-31 07:32:20.657 9600000 Chris 2013-01-31 10:14:16.817 20479000 The column i want to manipulate is the...
  19. Motlatjo

    The URL not working

    I have been trying to deal with this error for the past 2 week. This error comes when i try to use a link created by a subscribed report. The report server encountered an unhandled exception in HttpApplication. (rsUnhandledHttpApplicationError) Get Online Help c:\Program Files\Microsoft SQL...
  20. Motlatjo

    SSRS

    I have been trying to deal with this error for the past 2 week. This error comes when i try to use a link created by a subscribed report. The report server encountered an unhandled exception in HttpApplication. (rsUnhandledHttpApplicationError) Get Online Help c:\Program Files\Microsoft SQL...

Part and Inventory Search

Back
Top