Answer Questions

• Fiat Build report project failed but no errors.

  Hi In VS2003 I have a report project (SQL2000 RS SP2). When I build the project the compiler says the build failed (0 succeeded, 1 failed, 0 skipped). But the rest of the output window says there were no errors (Build complete -- 0 errors, 0 warnings). The task window is also empty. When I try to run the project I get a message box saying there were build errors and asks me if I want to continue or not. The reports all function normally (at design time and run time). Any ideas why I get the build failed error Stief. ...Show All

• amrhesham Error when i try to Deploy my reports to Reporting services - PLEASE HELP i'm also NEW at this

  Hi I'm running a SQL 2000 DB with reporting Services 2005 and Visual Studio 2005, I can connect and browse to Reporting Services through any management console and even to my site through //ServerName/Reports but when i try to deploy any of my reports to the Reporting Services through my VS2005 solution i get this error A connection could not be made to the report server http://Forge/Reports . Additional Information: The Attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer) The status of all of my things in Reporting Services Configuration is Green and i can see my site in the IIS, i can also browse ...Show All

• Yustme xp_sendmail

  Ok all...I'm not having much luck with this. I'm using SQL Server 2005 MSE I try to run xp_sendmail 'adam@getpaid4spam.biz' , 'This is a test' And I get the following error... Msg 17750, Level 16, State 0, Procedure xp_sendmail, Line 1 Could not load the DLL sqlmap90.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). Any ideas Adamus Adamus, I have finally found a machine to test this on myself, and have been able to successfully install and run the stored procedure, and I receive the email without problems. I'm using a machine with SQL Server 2005 Express, and I'm using the (IIS) Default SMTP Virtual Server as the mail forwarder. Did you remember ...Show All

• Kamarey OLE DB Destination fails with illegal instruction

  Environment: Server Windows 2003 SP1, VS 2005 I ran into this problem trying to deploy an SSIS package to a development server. I tested by creating a simple SSIS package on the server itself. Two blocks an OLE DB Source block and an OLE DB Destination block. Two tables in the same database, one the source, the other the destination. Connection manager test connection works fine. Package will execute from the IDE (locally on the development server), source block will read the table subcessfully, but when the destination block executes it fails and will stay yellow in the status screen. during the execution SQLDumper.exe is triggered. Analyzing the dump tells me: (2b40.2938): Illegal instruction - code c000001d (first/second chance ...Show All

• kperson Passing parameters

  I am working with Oracle 9i and Reporting Services. I have the following query: SELECT NOMBRE_POZO, SUM(TO_NUMBER(decode(LENGTH(RTRIM(FECHA_PLAN)), 1, 0, 1))) AS DIA_PLAN, SUM(TO_NUMBER(decode(LENGTH(RTRIM(FECHA_PROGRAMA)), 1, 0, 1))) AS DIA_PROGRAMA, TO_CHAR(TO_DATE(FECHA_PROGRAMA, 'dd/mm/yyyy'), 'mm') AS MES_PROGRAMA, SUM(TO_NUMBER(decode(LENGTH(RTRIM(NVL(FECHA_INICIAL, '-'))), 1, 0, 1))) AS DIA_REAL, CAMPO, ACTIVO FROM VPROGRAMA_PLAN WHERE (MODULO = 'RAP') GROUP BY NOMBRE_POZO, TO_CHAR(TO_DATE(FECHA_PROGRAMA, 'dd/mm/yyyy'), 'mm'), ANIO, REGION, CAMPO, ACTIVO HAVING (REGION = :region) AND (CAMPO = :campo) AND (ANIO = :anio) AND (NOMBRE_POZO = :uwi) AND (ACTIVO = :activo) When I use the pro ...Show All

• Paarul Regarding Collation for mirroring & Error 1418

  Can I know is it possible that if the database servers' collation in both principal and mirror server might unable to get the mirroring Because one of database collation is Latin1_General_CI_AS while another server (mirror) is SQL_Latin1_General_CP1_CI_AS . I did several type of troubleshooting but still unable to solve the Error 1418. All the ports are stated as started, able to use telnet to connect to the server's port but still unable to get a connection for the database mirroring. I do really need help on it. Thx for the assistance and kindness. Best Regards, Hans Hello Fernandes, Thanx for the reply and your information. I guess I forgot to give an useful information regarding ...Show All

• Daikoku can pocpet pc direct connect to sql server 2005?

  i plan to upgrade sql express to sql 2005 enterprise. if i upgrade to enterprise can i direct connect to sql server 2005, is it need to install other software on pocket pc or on my server thank you if you are creating a .NET Compact Framework application for your mobile device, then yes, you can use the System.Data.SqlClient namespace to execute queries directly against SQL Server 2005 Enterprise. Darren ...Show All

• Swapna.B. SSIS with transaction

  Hi I new in SSIS. I tried to do the simple package with transaction support. I do the sql task wich "delete from TableName" and then i do a simple data flow from one table to "TableName" which i deleted from data before. I wanted to use transaction that in case the data flow collapse the transaction will roll back the delete task of table. But then i exucute my package it stucks like the table is locked. Can any one help me with this package Thanks. Yes i used the package transaction option. In data flow the property of TransactionOption = NotSupported in data flow i make the Ole db data provider and do select query and the destination is a table in SQL serve ...Show All

• rokitsalad Help Needed ! , Data Migration from MS Access2003 to SQL Express 2005

  Hi , I have a requirement to migrate the data from an existing MS Access database to a newly designed SQL Express 2005 database . Need less to say the table structures in both are totally different.I would like to know how can i handle a scenerio where i want to map table A in access to table B in SQL express (the schema of both different and the number of columns can vary too) , how do i migrate the data from table A in Access to Table B in SQL express using SSMA Also i would appreciate if some one can tell me is SSMA the right tool for this , or should i use the upsizing wizard of MS Access.If there is no change in schema between source and destination databases (more of upsizing) then the process is pretty straight fo ...Show All

• CharlesF Installing SQL server 2005 express

  Hello, I have a problem installing SQL express from a CD, it installs fine but the installation wizard does not load automatically, so I have tried to setup manually through Add and Remove programs. But when I get pass System configuration check menu, i do not get the Registration info menu, it goes straight to SQL server express setup and then to another server express setup menu (it skips 3 menu pages) it should have MSML5 components such as SQL setup files, SQL native client, SQL VSS writer etc but it is completely empty. Then I get the finish screen. However, when I uninstall SQL express, I see the MSML screen with all the components listed before it uninstalls. I hope this makes sense and I hope someone can help. Thanks ...Show All

• stephanielauym .net and Sql Express

  Hi all, I have written a simple .net class to call sql functions like create subscription and sync replication. I am using merge replication. My Question is this:-- my class calls Microsoft.SqlServer.Replication.dll. On a machine that has SQL Express loaded it works but on a machine that does not have sql express it fails. I have made a setup project and deployed my "service". I added all references into the project and all works well on a machine that has sql express. We are running a network with 1 machine that has sql express and other machines that plug into this sql express. Is there a sql express runtime setup or do I have to load sql express on each machine. OR Am I deploying my class wrong. my setup project has the Micros ...Show All

• ravindranathw Unable to connect to the remote server

  Greetings: We have a copy of SQL2k Report Services running on a Windows 2003 Server. But the database used by the Reports is actually on another box in our network. (This is a option you can use during install.) This setup worked fine for about a year but now neither the reports and ReportManager no longer run. The Reporting services Log error is: System.Net.WebException: The underlying connection was closed: Unable to connect to the remote server. In a browser we get the error: --- " Directory Listing Denied " "This Virtual Directory does not allow contents to be listed." --- Turning on the option to list directory contents in IIS does not resolve the issue. Anyone seen this creep up before I ...Show All

• Ayhan Yerli (TR-NL) Performance Issues with Analysis Services 2005

  Hello I create a cube using SSAS 2005. The cube has 2 years' data. There are 4 dimensions (including date) . Thee are not large dimensions. THe largest dimension has 300 members. (other than the date ofcourse). I am facing serious performance issues while querying the cube. each query (click on a dimension member) takes about 15 seconds. I noticed that SSAS was using only 55 MB of memory - eventhough we have 2 GB on the machine. There was no meaningful information in Books online or technet on how to increase this parameter. All of the memory related items have the description "This is an advanced oiption that should only be changed with the advise of Microsoft tech support". Anybody else has run into this issue . I ...Show All

• R Raghu Conversion fails. Please analyze error msg.

  Msg 245, Level 16, State 1, Procedure CompactL1RecordsFromfirstINTRAD, Line 177 Conversion failed when converting the varchar value 'DECLARE rows_cursor CURSOR FOR SELECT ask, dateTimed FROM iDay_Compr_GOOG WHERE DAY (dateTimed) = ' to data type int. I get this message while executing a stored procedure. It works "half way" but skips this statement and the whole block as a result. In the table @table_name ask is declared as float and dateTimed as DateTime. Similar statements work happily in other stored procedures with no problem. Even in the same stored procedure I have places where I use DAY (dateTimed) and they seem to work as far as I can see although it is a very branched out code with many IF ... ELSE's. SET @SQL = 'D ...Show All

• Vladutz MDX - Filter by one date dimension and report on another date dimension

  Hi, I have a fact table in which i have more than one date dimension. The fact table is a periodic snapshot fact table. The Fact table looks like this FactInvoice PeriodKey InvoiceRaisedDtKey InvoiceUpdatedDtKey InvoiceClosedDtKey InvoiceAmount A weekly snapshot of all the invoices are maintained. I need a measure which will give me the number of invoices raised(created) during a given Period. Lexically, count of invoices created in the period to be reported against the Period. Both PeriodKey and InvoiceRaisedDate have hierarchies as follows: Year->Quarter->Month->Week I understand given the nature of the fact table i need to implement a custom rollup to produce the correct count as the count ...Show All