Answer Questions

• Markus Fritz Need basic help with deployment

  Hello I feel like an idiot here, but I cannot figure out how to get Reporting Services to work outside of Visual Studio. I have everything installed (using SQL Server 2005 Express), I have a report, it deploys but when I go to view it, I'm asked for a username and password. I found out how to allow annymous login, but when I do that it says I do not have permissions to access the report on the localhost server. I can view the report through Visual Studio just fine, but not outside of it. How can I get it to just allow me to view the report without logging in Any help would be greatly appreciated. Thanks -Jim Well it turns out the problem was that my default browser is firefox, and so it would deploy and ...Show All

• kemal Error creating Report Model based upon Oracle Database

  In MS Visual Studio, when creating a new Report Model Project, after defining a datasource to an Oracle database (and successfully testing it), and a simple datasource view (1 table), when I click "Run" in Report Model Wizard, I receive the following error: "ORA-02179: valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }" It does not appear that one can create Report Models from an Oracle database (since the SQL being used to query the Oracle database cannot be edited and contains syntax errors ). Is this the case Thank you. I have also encountered the identical problem. Has a resolution been provided yet Alexandre W ...Show All

• manjunath cv job running SSIS package keeps failing but the SSIS package by itself runs perfectly fine

  Hey, I've a few jobs which call SSIS packages. If I run the SSIS package, it runs fine but if I try to run the job which calls this package, it fails. Can someone help me troubleshoot this issue None of my jobs that call an SSIS package work. All of them fail. Thank you Tej Hey Peter. First of all, when I put these in MSDB, they worked fine. Also, I didn't try this but try to look for the security part for every package in its properties. It's encrypted with User Key or something. Remove the encryption and it should be fine. Let me know how it goes. Thanks so, sounds like the common issue of getting agent and package permissions in sync. for others, the ...Show All

• Will Harris SSIS Package Configuration Filter

  We have more than 100 packages which referenced many of the same data sources. In ideal situation, we would like to create three master filters based on the dev, test, and prod servers and all packages can just reference the same filters. However since one package normally only use a subset of master connections defined in the configuration files, if only those subset of connections are set up in the package, when the package is first open in BIDS, lots of errors will pop up saying that it could not find the connections defined in the configuration files. Even though this will not cost runtime error, it is still very annoying. Does anyone have better ideas on how to handle this Jamie, Thanks for your ...Show All

• modtran Transaction not working when inserting data into Oracle db using SSIS.

  Hi Guys, I have a package that inserts data from a sql server table to an oracle table. I use a dataflow task to do the loading. The weird thing is, if the package fails during execution, the transaction does not perform a rollback and the inserted data is committed. The dataflow component has its TransactionOption set to Supported (this has always been the case for our sql to sql packages). However, now that I have a sql to oracle package, it won't work anymore.. also, setting the TransactionOption of the dataflow component to Required causes the whole package to fail. Anyone have any thoughts on this Thanks, Kervy If the Required option fails, then that immediately ...Show All

• Steve1999 Export to SQL Server Everywhere Database

  Hello! I want to export a table in a SQL Server 2005 database to an SQL Server 2005 Everywhere database (sdf file). I use the assistent by calling "Management/Export data". The source is "SQL Native Client" showing to a certain database. The destination is "SQL Server 2005 Everywhere Edition" with an SDF File set. Then after defining the tables to be exported I come to a page showing me the steps of the export. At step "Before execution" I get the error messages (translated from German): Error 0xc0202009: Data flow task: OLE DB error. Error code 0x80040E37 Error 0xc02020e8: Data flow task: Error opening a rowset for "TABLE_NAME". Validate the existance of the object in the database ...Show All

• Ivo6070 Matrix - How to calculate % of row?

  Hi, I wish to create a matrix with multiple rows in the main data cell and a subtotal at the end of the row. The first row in my matrix main cell is just a count of records, whereas the 2nd row is a % of the value in the 1st row compared to the total of that row. I have 5 columns in the matrix as below (ignore rounding issues): Status A B C D E Total 01/01/2007 Number 9 32 3 13 0 57 % of Total 15% 56% 5% 24% 0.00% 100.00% Can someone advise the best way to calculate the % cells in this example Thanks Don't know if this is any use but whilst trying to find out how to add totals to my first matrix repo ...Show All

• krishna_aloha Problem importing Excel data into SSMS

  Hi, When I try to use the Import and Export Wizard to import a good .xls file I keep getting this error: "Could not find installable ISAM. (Microsoft JET Database Engine)" It occurs in both SSMS or SSIS. It also occurs with other flat files like .csv. The OS is XP, w/ office 2003.   here are the full error details:    at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection)    at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)    at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnecti ...Show All

• ajedi2k Application Role And SSRS

  Hi dear reader I made an application that uses a Sql Server 2005 Express DataBase. In the database I made a application role. When the user logs into my application I run this procedure: If Not sqlConnectionCR Is Nothing Then If Not sqlConnectionCR.State = ConnectionState.Open Then sqlConnectionCR.Open() SqlConnection.ClearAllPools() ConsultasSqlCommand = New SqlCommand ConsultasSqlCommand.CommandType = CommandType.Text ConsultasSqlCommand.CommandText = "sp_setapprole 'appRole', 'drowssap" ConsultasSqlCommand.Connection = sqlConnectionCR ConsultasSqlCommand.ExecuteNonQuery() End If Else.... I understand that this procedure connects to my sqlserver database ...Show All

• Quilnux Stored procedure parameter position

  Is there a way to determine the positional index of a stored procedure's parameters from within the stored proc The reasoning is this: I use raiserror state to return the index of any parameter values that are invalid or are otherwise not acceptable; like... if( @RequiredParam is null ) raiserror( 'blah blah blah', 16, 4 ); Currently I'm harcoding the parameter position which is a bit of a pain to maintain. I thought there may be a way of retrieving it so that it is robust against parameter changes; kind of... if( @RequiredParam is null ) raiserror( 'blah', 16, ufn_getpos( 'RequiredParm' ) + 1 ); Is sys.all_parameters and sys.procedures the way to go on this Hi, no this is true. YOu should always stick to the c ...Show All

• mike the novice help with a stored procedure

  here is my sp create proc [login] ( @email as varchar(200) @password as varchar(200) ) as begin select customerid from customerlogin where email = @email and password = @password End print 'Welcome' print (@email) End This works fine, but if the email is wrong, what do I need to add to this to print that the email is wrong and not print 'welcome email' Help, please..... create procedure sp_login @email as varchar(200) @password as varchar(200) AS Select CASE WHEN ((Select COUNT(*) from customerlogin where email = @email and password = @password) = 0)                 ...Show All

• Kosmo007 MDX - Case ?

  Hi, Im using AS 2005 and I want to display a measure depending on the level of the hierarchy My hierarchy is as following : Level A Level B Level C Level D if the user selects Level A, I display the measure Sum_LevelA if the user selects Level B, I display the measure Sum_LevelB I suppose I should use MDX to do this (kind of CASE ) but im a newbie at MDX. Thanks in advance for your help. JL Here is the best way to do it in AS2005: CREATE MySum; SCOPE (MySum); Dim.LevelA.LevelA.MEMBERS = Sum_LevelA; Dim.LevelB.LevelB.MEMBERS = Sum_LevelB; ... END SCOPE; HTH, Mosha ( http://www.mosha.com/msolap ) Mosha, Thanks a lot for your reply ; I a ...Show All

• RagsIyer SSIS package very slow in design

  Hello, I have designed a quite small SSIS package and everything worked just fine . Untill I moved the SSIS project folder to another solution folder and added whole solution to Visual source safe. Since then opening the package for design has become unbelievably slow, debugging it even worse. I think the cause is in moving the SSIS project folder. But I have no idea how to fix this. Any suggestions Janez I have a package with similar behaviour, but not jet found a solution. I’ll let you know if I figure it out. Have you tried turning on "delay package validation" Check the warning and error output when lo ...Show All

• cashrolls2 Two questions around Date

  Question 1: I am passing a datetime as a parameter to a Stored Procedure. The datetime may contain time, which I want to strip out - the date is the important part and it is critical that the time is 00:00. What is the most efficient way of stripping out the time so that it is 0 Question 2: I have a Year (small integer), Month (tiny integer), and Day (tiny integer). What is the most efficient way to use these to make a datetime In both questions, please assume that a universal standard must be used, since the database in question may be running outside of North America. Many thanks, Flavelle FOR NO 2. Try this declare @year int declare @month int declare @date int ...Show All

• suddenelfilio send mail task

  hi. i want to use the send mail task but i want the recipient's address to be a parameter and the content of the body as well to be based on parameters. is it possible to do that using the dts   if not what is the equivalent procedure in sql server to do this Thanks Hi. You don't need any .dtsconfig file. You can do that in 2 steps. First create variables for the to, cc and bcc in your package. In the control flow, use the Execute Sql Task to load the values from the table into these variables In the send mail task, use the expressions to set the values of to,cc and bcc to the values of their corresponding variables. Hope this helps Christina Make s ...Show All