Answer Questions

• chooinggam Database Documentation

  Hi guys, my manager asked me that to do documentation; right now we are using MSSQL SERVER 2005 Databases, here you assume I am new to make documents on any database but good idea about databases currently that data warehouse in development environment need to done this documentation before go on test environment . So that way you advise me to prepare a document. Here is my main concerned how to start and what things should we keep in mind while preparing document (what are measurements).if you any prepared documents could help to start or there tool we should use (power point) them. any help appreciated Things to include in DB documentation, and some suggested sources: 1.Server where DB is implemented; SQL Server ...Show All

• Quirk Using stored procedure as OLE DB source with parameters from package variables

  Hi Guys, (I have searched this forum extensively, but still can't find the solution to this problem) Here it is: I have step in my ETL process that gets facts from another database. Here is how I set it up: 1) I have to package variables called User::startDate and User::endDate of data type datetime 2) Two separate Execute SQL Tasks populate those variables with appropriate dates (this works fine) 3) Then I have a Data Flow Task with OLE DB source that uses a call to a sproc of the form "exec ETL_GetMyData @startDate = , @endDate = " with parameters mapped accordingly (0 -> User::startDate, 1 -> User::endDate) When I run this I get an error 0xC0207014: "The SQL command requires a parameter nam ...Show All

• big4ared Need scope for RowNumber( ) function

  HI ... I have a detailed report ..with summary lines and detailed lines (drill down). I have a column with a function "RowNumber(Nothing)" which is supposed to just count the rows when I put this in the summary row for the column I need in the Design Layout section and run the report, I get numbers on the summary lines which include the number of rows in the level below (detailed rows). I just want to number the summary rows sequentially without taking into consideration, the number of detailed rows. How do I modify RowNumber(Nothing) to exclude counting the detailed rows.... Any help will be much appreciated...thanks This was exactly what I was looking for thank you very much, you have bee ...Show All

• kreigh Errors in the metadata manager

  Hello, I'm trying to process a cube and i'm getting the following error message. I'm not working in Analysis Services Project 4, i created another project. I deleted Analysis Services Project 4 and every project i try to execute i get this error message. "Error 1 File system error: Error opening file; \\ \C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project4.0.db\TBLE~MC.0.cub.xml is not a disk file or file is not accessible. Errors in the metadata manager. An error occurred when loading the TBLE~MC cube, from the file, '\\ \C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project4.0.db\TBLE~MC.0.cub.xml'. File system error: The following error occurred while writing to the file ...Show All

• David_JS domain\user cannot log on SQL server 2005

  Hi All, I have an issue to connect to SQL 2005. My user is also declared in SQL 2005 as sysadmin. C:\>ECHO %USERDOMAIN%\%USERNAME% CMVAL\damien C:\>sqlcmd -S CM-DB 1> quit C:\>sqlcmd -S CM-DB -U "CMVAL\damien" -P "ThePassword" Msg 18456, Level 14, State 1, Server CM-DB, Line 1 Login failed for user 'CMVAL\damien'. C:\> Seems that the system reject the domain I've provided. Some of my service failed to log to SQL Server due to this issue. Thanks for your help. Damien By default, sqlcmd uses Windows Authentication. If you are using windows system, then you automatically get authenticated through windows authentication mode by not using -U options. ...Show All

• imanish11111 SQL Server Active/Active, Possible?

  Dear all, I am a newbies in SQL server. One of my client what to using Clustering and SAN Feature to make his SQL server have high avaliabilty. However, since they want to utilize the SQL server, they would like to active/active cluster with network load balancing. However, questions comes: 1. Can I mount a same database in a Active/Active Cluster environment 2. If I can do that, how will the SQL server handle those instance/how can I set it up 3. When there have two users using difference node SQL server to insert data, what will happen Please help. Thanks and Regards Jacky SQL Server's implementation of clustering is not a RAC-like solution. It is not a load balanced/scale out solu ...Show All

• Krutika difficulty in getting result.

  hi all i am working on sql reporting 2005. i have 3 reports say A, B ,C i want to display sum of values in column of A & sum of values in column of B in report C How can i do this plz help me. report c would have to have the same data as in reports A and B. Then you can sum them. ...Show All

• clueless in chicago OLE DB Command and Destination writing to the same table

  Hi, I have a data flow task that performs an "upsert" by directing successful rows from a Lookup to an OLE DB Command that updates rows and unsuccessful rows (Lookup error output) to an OLE DB Destination for insertion. The problem is that execution hangs when both tasks update/insert into the same table (execution is still hung after 20 minutes). Modifying the OLE DB Destination to insert into a different table succeeds (execution completese within 2 minutes). Replacing the OLE DB Destination with a Row Count transformation also works. Could this be due to a table-locking issue Any suggestions Thanks ray You might look at the slowly changing dimension task... I'm not that familiar witrh it.&nb ...Show All

• laqula how to deploy reporting services into different folders

  Hi, can i deploy reporting services rdl files into different folders in RS will it be able to create the folders by itself or do i need to create them beforehand thanks for any answers. - HY Alternative: Create several proyects in the solution, each proyect for diferent folder on the report server. if you have a folder named "services" and two subfolders "names" and "subreports" you can do this: -Solution: "My solution" --- Proyect 1: "Reports services - names" target report folder: Services/names --- Proyect 2: "Reports services - subreports" target report folder: Services/subreports an ...Show All

• Seraph_78 query for recordset data into sql table

  Hi, i have a recordset on an asp page and put into session now i want to move this recordset data from session to sql server table.how can i query this.Pls suggest me... any suggestion will be appriciable... Thanks thanks jens for the information ... but i am using classic ASP recordset Hi, depending on your version of ASP the work to be done can differ, but here is the ASP.NET 2.0 approach, if you have the data in the session: -Get the data from the session -cast it to a usable data object (like datatable) -Use a sqlcommand or datadapter to update the data on the database (depending on your implemented database interface, DML Command Access or SP access this can differ) HTH; Jens K. Suessmeyer. --- ...Show All

• RedCoat999 x64-Bit Install of SQL Server 2005

  I have a AMD 64-bit multi-processor server that is currently running the 32-bit version of SQL Server 2005 without any problems and we are using it. (I followed the instructions on how to install the x64 version of the v2.0 of the .NET Framework and it is running properly.) Now I want to move forward with installing the 64-bit version of SQL Server 2005 and the associated services such as SSIS, SSRS, and SSAS. The plan is to basically uninstall the 32-bit version of SQL Server and then just install the x64 version, Are their any issues with the installation I didn't see any 'read-me' on the x64 DVD disk. While we have lots of experience with 32-bit installations...this is our first x64 box...so I thought I should ask. Thank you. ...Show All

• Gafrage Upgrading from SQLS2K to SQLS2005

  My organization is planning to upgrade sql server 2000 to sql server 2005. One of the main reason to upgrade, is to utilize new security(encryption) feature provided by the SQL server 2005. Our main aim is to encrypt few columns of the database tables. I am in a dilemma on how to encrypt tables which already has data in it We have VB application that uses SQL server 2000 as backend. I do not want to change the frontend. Is there any why we could save the data in an encrypted form without changing the frontend Thanks Ks doeThanks Laurentiu. It really depends on your application (for example, if you allow ad-hoc queries so they can manually open and c ...Show All

• George. Change the WHERE conditions dynamically

  Is there a way I can build a case statment or similar to handle different where conditions I know I can do it dynamic sql but it would be nice to have a method where I can create the querries directly in a normal statement Someting like: Select c1, c2, c3 From Table WHERE Case @Condition WHEN '>' @SelColumn > @Limit WHEN '=' @SelColumn = @Limit WHEN '<' @SelColumn < @Limit END I know this doesn't work so an example that do work would be nice. Can't you use a T-SQL IF statement instead IF @Condition = '>' SELECT ... FROM .. WHERE @SetColumn > @Limit ELSE IF @Condition = '=' .... WHERE @SetColumn = @Limit This will get you the best performance i ...Show All

• Michal Golawski Pass data to a report?

  Hi all, We have an ASP.NET application that generates various reports and word documents. The word documents and the reports require the exact same data and we have written some rather complex functionality that generates the SQL select statements to fetch this data. The statements are currently being used to create ADO.NET DataSets which feed the word documents. How can we now get these DataSets to feed the reports too We would really, really, really like to avoid having to recreate the logic for constructing the select statements within SSRS. Can we pass the DataSets themselves, or can we serialize them to XML using the WriteXml method then pass the Xml data as parameters or is there a way to just pass the SQL to ...Show All

• Jassim Rahma Data Flow Source for dbf (DBASE IV) files

  We're trying to read DBASE IV files as a source, but can't find any providers for that format. Will these be included in the final release Is there another way DBASE has always been supported, so it's kinda stranged. Thanks, Dirk The Visual Foxpro 9.0 oledb driver can be downloaded from http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx Foxpro can import files from dBase, but its file formats are different and it might try to update the format.  If you try it, test it out on a copy of the file.  If you can get the dBase IV driver to work as described above, I would recommend that. -Evan Black I've searched previous support incidents and newsgroup postings involving the " ...Show All