Regarding to the question in the post http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=2088514&SiteID=1&mode=1 I am looking for a formular to overwrite the Price on all tuples exept leave granularity with price=turnover / quantity...
If i Simply do price=turnover/quantity I get an infinite recursion. I only need non leave granularity tupples - but howto wirte the scope therefor

I am inserting rows using OLEDBDestination and want to redirect all error rows to EXCEL Destination.
I have used Data Conversion Transformation to Convert all strings to Unicode string fields before sending it to Excel Destination.
But its gives the following error.
[Data Conversion [16]] Error: Data conversion failed while converting column 'A' (53) to column "Copy of A" (95).

I am creating many calculated members for a cube with several measure groups. The problem I am having is that when browsing the cube, all of the calculated members appear at the bottom of the measures area. I would like to organize them into the folders under the measure groups where they belong, but do not see a way to do this. Does anyone know if this is possible
Thanks!

I'm running the following stored proceudre that I will eventually be using checboxes and a sqlDataAdapter to fill a DataGrid using VB.Net.
When I attempt to execute the SP on the server side for testing, it throws me the error "syntax error converting datetime from character string".
conversion of datatypes is something I'm still new to so I can't begin to understand how to

I am using the Script Wizard to generate a script to create all of the objects in my database. I have some unenforced FK constraints but whenever I run the script to craete my objects it keeps creating them with checking even though it does not say anywhere in the script to do anything other than unchecked on the FK.
If a manually alter a FK to be unenforced and then right-click to generate

Hi,
I have SSIS package which is created to pull data from oracle server. The package is running fine when executing from BI studio. But failing when i execute as a job. I am getting teh below error message.
Microsoft OLE DB Provider for Oracle" Hresult: 0x80004005 Description: "Oracle client and networking components were not found. These components are supplied by Oracle

I've just install SQL Server 2005 and successfully navigated my way through using the Maintenance Plan to backup my databases but can't figure out how to keep my transaction logs from getting huge. Is this controlled by a Maintenace Plan and, if so, what is the preferred setup

I have installed the evaluation version of SQL Server. When i click on the Intelligence Development Studio link it starts looking for the file devenv.exe. The file is not on the pc. Repeated installation twice making sure that all components are selected. What is causing this file not to be available
Haris

Hi ! I think I need your help... to convert the date (2006-09-09) to weekday, weeknumber, month number, month, year in OLE DB source editor ... created following sql, which is not working. How about using derived Column transformation editor SELECT DATENAME (WEEKDAY, YYYYMMDD) AS weekday, DATEPART(WEEK,YYYYMMDD) AS weeknumber, MONTH(YYYYMMDD) AS month_number, DATENAME(MM,YYYYMMDD)AS Month, YEAR

Hello:
I was trying to install SQL Server 2005 and all other Servers on a Windows 2003 Server.
One of the error messages I got was
"TITLE: Microsoft SQL Server 2005 Setup ------------------------------
SQL Server Setup was unable add user NT AUTHORITY\SYSTEM to local group SQLServer2005MSFTEUser$VENKAT-W2003$MSSQLSERVER.
For help, click: http://go.microsoft.com/fwlink LinkID=20

Hi,
I'm new to mdx and i have this code which keeps prompting an error:
/*
The CALCULATE command controls the aggregation of leaf cells in the cube.
If the CALCULATE command is deleted or modified, the data within the cube is affected.
You should edit this command only if you manually specify how the cube is aggregated.
*/
CALCULATE ;
WITH MEMBER [Measures].[TotalC

Hi
I have a simple data control task that has an OLE source and OLE target.
the source is a SQL query that returns 200m records this is then written straight out to a table. I have used a data flow task so that I can chunk up the inserts rather than using a INSERT INTO.....SELECT FROM.
I have ran it multiple times and it hangs once it reaches 18,961,020 records.
there

I am a beginner for sql server database developer
I was told to prepare SMART Goals for the year,which I don't have a clue to do so.
Who helps me how to do it and which competency areas I should concentrate on for a small company of 50GB database
Thanks

I have a table containing over 100,000 email addresses. This email table gets duplicates in it, and our customers don't want a second (or third or fourth) copy of our news letter. To prevent this, we run the following SQL to kill the duplicates:
Code Snippet
DELETE FROM _email WHERE _email.eid IN ( SELECT tbl1.eid FROM _email AS tbl1 WHERE Exists ( SELECT emailaddress, Count

How should I go about releasing any objects I've created I've got a very complex CLR stored proc that creates a dataset, many sqlcommand objects, an adapter, etc, etc. It's used to evaluate high school transcripts for completion of the core subjects. It's a very complex SP that takes a single SSN as a parameter.
Right now it works as expected when I call it from a query window in SQL Mgmt Stud

If I create a backup using the following T-SQL, is there a specific reason that I cannot restore it through Mangement Studio.
BACKUP DATABASE MyDB
TO DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\MyDB_1.BAK'
WITH FORMAT , COPY_ONLY , NAME = 'Backup of MyDB'
I can still restore it using T-SQL but would like the conveinence of using Managment Stu

Hello Everyone,
I have defined a cube with translations on every dimension and measure group.
when I query this cube from BIDS, the captions of each column have text in the right language (whatever is chosen in BIDS at the time of query)
Now, my customers will be sending queries from SSRS. when i fire the MDX query from SSRS I want to extract the MEMBER_CAPTION dimension prope

Hello All,
I am trying to set up Log Shipping, but, in the second screen of Database Maintenence wizard, when I select any database, the log shipping option gets grayed out. I am not able to select both. But in the step by step guide, it mentions to select both. I could have provided a screenshot of what's happening, but I could not locate a place for the same. Please let me know about this at

I bought a new HP server with Windows 2003 SBS Premium.
I also was told buy the company how installed the server, that they installed all the components of SQL.
When another company came to install a new business software for us, they told me that the Integration services is not installed.
We tried together to install the SSIS with no luck.
When we run the Setup(or used Add/Remove soft

I need to develop a web-based (intranet) database application. Would SQL be the best product for the data storage And would it be available "real time" for statewide input (In other words, not needing replication).
Thanks in advance for your patience and assistance.

This works correctly in the Business Intelligence Dev Studio tool and on one of our servers, but fails on the other two servers. The two servers that do not work are current on their patches. When a matrix has multiple rows and multiple columns, the highest level column subtotal is in the wrong scope. Say we have three row groups (r1, r2, and r3) and two column groups (c1, c2). All five groups hav

I read a couple of articles related to encryption topic in this forum and I feel that's really helpful I don't know if anyone has some knoeledge about the encryption issues in replication and clustering environment. I read some documents from Microsoft web site that explains how to move an encrypted database from its original server to another new server instance. That cause a lot manual works, if

We have upgraded our database server from SQL 2000 to SQL 2005. To migrate the DB I attached the mdf file in SQL 2005. After migration website loads quicker than earlier but records updation ( no of records are 20k) got slowdown. I have found that update query run very slow in SQL 2005 as compared to SQL 2000. Although other select query run very faster. Query is called from ASP (active server pag

Hello all, I have a question. I am fairly new to all of this, so bear with me if it is something simple (as I kinda hope it is).
In SSRS, I have a report that runs against a SQL '05 DB. The DB tables are created with a SSIS package gathering information from an AS/400 DB2 database.
The package and report run fine. One of the columns in the table is for a date (date of birth). The SSIS packag