Search results for query: *

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

...can see the statement visually. Keep the joins etc in the select statement, but replace the columns in the select part of the statement with count(*). Run this statement to see the count of records that match this query (in your case, it's probably 0). One by one, remove each dimension...

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

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

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

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

Thank you! Thank you! Thank you! Thank you! Thank you! Thank you! [bigsmile]

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