Recent content by mojoT

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

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

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

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

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

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

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

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

Cool, thanks guys.

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

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

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

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

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

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