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

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

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

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

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

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

I've managed to get my child forms to open in the top left corner of my MDI using the me.left = 0 and me.top = 0 in the child forms load function. The start position property is set to Windows default. Is it better practice to do it the method above, or should i just change the start position...

I have a rich text box field in my MDI to display help messages, that - thanks to FAQ796-3279 - I can fill from one of my Child Forms. What i need to do now is fill the text box from the child form with information stored in a SQL Server database. Where do I put the data adapter and dataset...

I'm working on a project where one of the tables' primary key has 10 characters. The first five are the same letters for every record, but the last five need to be an auto-number. Does anyone know how to do this???? I talked to an oracle user, who said i can concatenate two fields, or use a...