Answer Questions

• Dan Devine Steps for creating perfect OLAP Database!!!

  hello all, Can anybody pl suggest me what exact steps should be followed for creating OLAP database . Which issues should be considered thanks, deepti Hi Deepti, There is a good deal of guidance on best practices in this Project REAL paper - though "perfect" is a tall order. Obviously, this may not cover all your specific scenarios: http://www.microsoft.com/technet/prodtechnol/sql/2 ...Show All

• JinMaster Change request: Parameter mapping

  In some places in the SSIS enviroment, you can use parameters in queries, for examples in the query part of the OLE DB Command component. You do this by specifying placeholders using question marks. The question marks result in parameters on the Column Mappings tab of the Advanced Editor named Param_0, Param_1, etc. When adding question marks to the query later on, new parameters are created named Param_<x>, where ‘x’ is the next ...Show All

• Loane Sharp Very new to SQL Express

  I hope someone can help me out. I downloaded SQL Express and I'm having trouble finding a graphical user interface. The only items I've been able to locate are the Configuration tools. Is there something else I need to download Christian, To use the graphical interface provided by Microsoft (SQL Server Management Studio Express), you can either : Download SQL Server 2005 Express Edition, and then down ...Show All

• Vinod1239 Snakebit!

  Right now I feel totally snakebit by Reporting Services. I can't seem to get anything correct. I completly uninstalled SQL Server 2005 June CTP and reinstalled. When I configured Report Services it said that the virtual directory could not be created. The previously set directory will still be used. However, the virtul directory buttons stayed red. I would like to totally remove Reporting Services and reinstall and hopefully get it working corre ...Show All

• mEt Installing SQL Server Express edition

  When I try to Install SQL Server expres edition I keep on getting this error: http://www.fambouman.com/SQLError.JPG I'am running Windows SBS 2003 fully updated via windows update.. When I go to the URL mentioned in the error I get an error and the browser redirects to microsoft search. Anybody know how I can setup SQL Expres I need it for dotnetnuke to run. Thanks in advance Sorry for the 'Dut ...Show All

• MrFile How to use YTD on a mirror period

    Hi friends   I have a funny situation. I have a period dimension which contains Year, Qtr, Month. I also have another Time dimension which contains Mth1 .. Mth25.   The 2nd Time dimension matches that of the 1st Time dimension ie. Mth25 is 2005.April. and Mth24 is 2005.March and so on...   However I need to calculate YTD when MTH25 is selected from the dimension.   I can't exactly do YTD (Mth25) as Mth25 is not ...Show All

• GavinG How to create a new named instance

  Hi, I did install SQL-server developer edition. During the installation it asked me the name of de instance. I let the installation create the default Named instance. Now I want to add an instance with a new name. What is the best way to do this Is this the same as creating a Notification service Doeb Simply run setup again, this time choosing a named instance instead of the default. Each instance wil ...Show All

• BJB Index was outside the bounds of the array

  Ok, all I did was to create a new report, new dataset, hook it up to a simple stored proc. I can run that dataset fine and see the date in the Data tab. I go to the layout tab, throw on a textbox...or even try dragging in a field from the dataset tab, then try to preview and get the error "Index was outside the bounds of the array" what is it talking about, what array, what index the dataset Thank you all, it must have been ...Show All

• Mindaugas Luko?ius Import CSV file data from URL/HTTP

  Hi, I'm truly a newbie to this, so please ignore any stupidity :-) I am trying to (in SQL2005 - integration services) 1) Import a CSV file over http (using an URL) 2) schedule the job (so it is done regularly) 3) *bonus* edit the URL dynamically I have a web link, e.g. http://dummy.com/cgi-bin/run.cgi from=050101&to=050102 when accessing this "page" the result is sort of a CSV file. It looks something like this: Date;cus ...Show All

• restore Problem with Custom Security Extensions

  I have tried and tried to get the "Security Extension Sample" to work. I can browse to http://myserver/Reports and http://myserver/ReportServer and get the custom logon form. But, when I try to register or login I get System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: An error occurred while attempting to verify the user. An error has occurred while establishing a connection to ...Show All

• Paul Deckers execute SSIS package stored in remote SQL server from a client machine.

  I have written a VB component to execute a SSIS package stored in SQL server. I am using the Microsoft.sqlserver.dts.dtsclient, dtsconnection/dtscommand and executereader and everything works perfect on the local machine. This is descibed in a msdn site . But my customer have a remote SQL server and want no extra BI clients/SQL server clients etc on the client machine, only an ordinary windows client and network connection to the SQL se ...Show All

• SalvaPatuel Character limit on Data tab?

  Does anyone know if there is a character limit on the data tab of SRS 2000 I have a report that requires a lottt of sql and when I copy and paste the sql from Query Analyzer to the data tab, not all of it gets copied there, and it will not let me enter another character.   Thanks, Jeff Yah...good thought...thanks. It may make more sense to encapsulate in a stored procedure if possible.  It does sound like you have ...Show All

• Malicious User An article on FOR XML in Microsoft SQL Server 2000 and 2005

  I just posted article What does server side FOR XML return ( http://blogs.msdn.com/sqlprogrammability/articles/576095.aspx ) which gives some details of the design and performance characteristics of various FOR XML flavors. The article is posted to SQL Programmability & API Development Team Blog ( http://blogs.msdn.com/sqlprogrammability/ ) Best regards, Eugene Kogan Technical Lead Microsoft SQL Server R ...Show All

• Evan_Chang Problem using dates in XMLtoFLFF Transformation

  I am having a bit of trouble transforming a XML (xs:date) type to the DBDATE in my FLFF. I believe the problem is because the SSIS DF (Metadeta) converts xs:date to DT_DBTIMESTAMP which becomes 01/01/2005 00:00:00 -- appending the time. So when I try to transform in my fixed length flat file, it throws a truncation error when the length is set to 10. (which is the length of date) Is it possible to (A) use some other xs format that ...Show All

• myoungbl Data of type SQLBIT always 1??

  Hello all, Apologies if this is posted in the wrong forum, however I wasn't exactly sure as to which one would be the best for my query... I have recently inherited the job of maintaining a database of internet logs and I am using the bcp utility to bulk insert rows into the database. The problem is that for the fields which are classified as SQLBIT in the .fmt file (and the field in  the database is bit) are always inserted as '1' e ...Show All