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 Chriss Miller 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: mojoT
  • Order by date
  1. mojoT

    Dynamically configure drillthrough

    Hi. I've been tasked with altering existing ETL processes to reflect changes in the data, and to also alter an existing cube which will be using this data. My question is, can you filter the drillthrough results based on whether a particular dimension has been used or not, and if it hasn't...
  2. mojoT

    how to modify a data by removing a protion of it

    Just out of curiosity, when you said you want to get rid of everything after the dot, did you mean update the table, or as a select? I'm assuming it's update. genomon's way should work, although it assumes there is always one digit after the decimal, so if it is, then go with that. If however...
  3. mojoT

    Can there be workflow precedence between datapumps?

    Hi You can use two connections (provided they are the only ones you need), but personally, I prefer dragging on new server objects and setting them to the existing connections as it's easier to see the workflows etc... I suggest you do it that way, set up all the transform data tasks as you...
  4. mojoT

    Can there be workflow precedence between datapumps?

    Hi joelwenzel You can have different connections or use existing ones. For example, you may have a connection called Source and one called Destination. To reuse these, you can have multiple transform data tasks between the two icons, which are controlled using workflows. An alternative to...
  5. mojoT

    Multiple server connections in DTS

    Perhaps you need to do this: SELECT * FROM [ProdServerName].[DBName]..[TableName] WHERE ID IN ( SELECT ID FROM [DevServerName].[DBName]..[TableName] ) Try it in Query Analyzer to make sure you're getting the right results (substitute...
  6. mojoT

    Extra decimal places when importing from Excel

    While 3.1 is the only value for that column at the moment, it is highly likely that there will be valid alphanumeric entries, for example, 3.a.1 etc... therefore 3.1 needs to be treated as a varchar, not as a number. The table that the data is being imported into has varchar(255) for all...
  7. mojoT

    Extra decimal places when importing from Excel

    Hi I'm trying to import data from Excel into SQL Server via DTS. The columns in the destination tables are all varchar(255). I have a column in Excel where the values for all rows is 3.1, however this value becomes 3.100000000001 once it's been imported into SQL Server. Can anyone shed some...
  8. mojoT

    Executing DTS from Stored Procedure - Package Hanging

    I'm working on a quick and dirty solution that, having only been given the problem yesterday, it needs to be tested and up in production tomorrow. I'm running a DTS package from within a cursor in a stored procedure. The first time I enter into the cursor the DTS package looks like it executes...
  9. mojoT

    ODBC Connections vs MS OLE DB Connections

    Cool, thanks guys.
  10. mojoT

    ODBC Connections vs MS OLE DB Connections

    I'm creating a DTS package to import data from one SQL Server to another. My approach was to add two Microsoft OLEDB Provider for SQL Server connections, but looking at my predecessor's work, he's chosen to make the source connection an ODBC one. Is this necessary, seeing that both source and...
  11. mojoT

    Error not allowing users to drillthrough

    Has anyone ever seen this error?: "Could not get detail records for this aggregate. Make sure that permissions to obtain drillthrough records are set properly on the OLAP server." Our setup at work is we have a web application that uses OWC to access our DataWarehouse. The above error occurs...
  12. mojoT

    No data in OLAP

    I could be wrong, but whenever I have more records in my fact table than my cube, it's usually because the values in my dimensions do not match some/many values in the corresponding field in the fact table. This is from my experience, and there may be a faster/better way to do this, but to...
  13. mojoT

    Specifying drillthrough options

    Is there any way, other than analysis services, that you can specify the drillthrough options of a cube (any type of cube)? I want to try something on one of our production databases, but would rather include it in our regular processes. It includes disabling drillthrough on a cube, then later...
  14. mojoT

    Can you create relationships between tables in different databases?

    Is that in all databases, or just SQL Server? And why can't you? If I have a reason, then maybe I can justify it to my boss
  15. mojoT

    Can you create relationships between tables in different databases?

    I have about 6 databases that I've made/making and some tables are required in more than one database. These tables, which are used primarily as lookup tables for combo boxes etc, are hardly ever updated. We're looking at creating a common database to store those tables that are needed by more...
  16. mojoT

    Message Box - YesNo with a Question

    Hiya All I want to have a YesNo msgbox in my Windows application, but with a Question Mark icon. So far I've tried: MsgBox("Message", MsgBoxStyle.YesNo.Question, "Title") and MsgBox("Message", MsgBoxStyle.Question.YesNo, "Title") The first one Shows...
  17. mojoT

    Getting Data from a list box or text box

    Thanks so far for the response. In answer to BitDoctor's questions, sometimes the application will be able to generate the serial numbers, sometimes it won't. I'm asking the question for the times the serial numbers aren't generated. I apologise, I should have explained my problem a bit...
  18. mojoT

    Getting Data from a list box or text box

    I'm working on a windows application with a SQL Server backend that deals with stock control of books. A book has the option of being serial numbered, and the first time that book is recieved, the user has the option of manually entering the serial numbers they want. This is where I get stuck...
  19. mojoT

    Referencing an MDI from a Child - Where do i put the Dataset???

    Thank you! Thank you! Thank you! Thank you! Thank you! Thank you! [bigsmile]
  20. mojoT

    Referencing an MDI from a Child - Where do i put the Dataset???

    So, just for instance, instead of having to store everything in text files, could i make my table as follows: ID Title HelpText Then just use the rtf.AppendText(Title) and bold it or whatever, then go rtf.AppendText(HelpText) So that it looks nice? And then i don't need to worry about having...

Part and Inventory Search

Back
Top