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 derfloh 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: *

  1. yksvaan

    Powerplay server stops

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

    Line Comment

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

    Import error from Excel, Alpha vs Numeric

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

    Newbie to DTS - Email text contents

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

    Showing latest inventory levels as a measure

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

    Cube Build time

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

    Converting date and week # to monday date?

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

    UDL Creation

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

    where to get syntax reference?

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

    Cube Build time

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

    Cube Build time

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

    Calling a stored procedure from DTS

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

    Help using RegExp in a column Transformation

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

    UDL Creation

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

    How to set source and target externally.

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

    DTS package not copying full set of data

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

    DTS package not copying full set of data

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

    Error creating DTS to put file on FTP server

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

    importing date fields

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

    Filter/Suppress Category in Transformer

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

Part and Inventory Search

Back
Top