Answer Questions

• JonnyAJAX ole db source query assistance requested

  my query is below: "SELECT * FROM " + @[User:: TableName] + " WHERE OrderDate = " + "'" + @[User::dTrxnDate] + "'" needless to say, the ole db source editor is giving me syntax errors. the data type of TableName is string. the data type of dTrxnDate is DateTime. can someone please help me resolve the syntax errors thanks in advance. Rafael Salas wrote: Duane Douglas wrote: i'm still seeking assistance. Duane, The Ole DB Source only understands SQL, you cannot use SSIS expression there;tWhat you have to do is to put your expression in a variable(create a variable and then press F4 to get access to the propety pannel) and the ...Show All

• SankaraNarayanan Nagalingam Problem with store procedure

  I have the following error when I execute this stored procedure. Can someone please help Msg 208, Level 16, State 6, Procedure InsertIndicator, Line 28 Invalid object name 'dbo.InsertIndicator'. set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo] . [InsertIndicator] ( @Module nvarchar ( MAX ), @ModuleID int , @Indicator nvarchar ( Max ), @ReturnValue int Output ) AS Select Module FROM Modules Where Module = @Module IF @@ROWCOUNT >= 1 Begin Select Indicator FROM Indicators Where Indicator = @Indicator IF @@ROWCOUNT = 0 Begin INSERT INTO [dbo] . [Indicators] VALUES ( @ModuleID , ...Show All

• nepenthean Sharepoint Integration Microsoft.ReportingServices.SharePoint.UI.WebParts.dll

  Does anyone know the location of Microsoft.ReportingServices.SharePoint.UI.WebParts.dll after you install the web part I am wondering if I can inherit from this web part to wrap some other functionality into it. I know that i see it in the GAC buyt can't seem to find it so I can look at the assembly using reflector. Also, how easy is it to pass in parameters to the Report Viewer Thanks! Erik The GACView utility will allow you to extract it from GAC but I don't think you will get too far trying to subclass it. To my understanding, the RS web parts cannot be extended, nor can the parameter prompt area although Microsoft.ReportingServices.SharePoint.UI.WebParts.ReportViewerWebPart has be ...Show All

• Radim Hampel 'Could not allocate space for object 'dbo.SORT temporary run storage'

  Hello all, I’m trying to transfer/transform some data from one table to another, both on the same database. The source table holds 92M records. To do so I'm using the next statement: INSERT INTO [dbo].[Messages1] ([Time] ,[ID] ,[ResponseTo] ,[MessageMD5] ,[source] ,[dest] ,[arln_err] ,[ErrorDescription] ,[ErrorNumber] ,[ErrorSource] ,[ErrorType] ,[HttpCall] ,[HttpStatus] ,[QuoteAmount] ,[ReservationPickupLocation] ,[RatePickupLocationDescription] ,[RateReqCarType] ,[RateReqPickupLocation] ,[RejectMessage] ,[ReservationAmount] ,[ReservationCarType] ,[ReservationCarTypeDescription] ,[RatePickupLocation] ,[resp1] ,[ResultNum] ,[strRejectMessage] ,[strResultNum]) SELECT [Time] ,[ID] ,[ResponseTo] ,[MessageMD ...Show All

• Shrini Unable to connect

  I am unable to connect SQL Server Management Studio to any of the databases on my computer. At this stage I am simply starting the Management Studio and asking it to connect to a database I made a few months ago before this connection trouble arose. I'm specifying the server name "BENCHLAP" which is the name of My Computer, using Windows Authentication. The error I get is: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) The client is local. At least, it is if I unders ...Show All

• AVVIT Time Series only predicts one step

  I have a relational table with daily sales for 364 days (52 week span) for 60 stores. I have created a Microsoft Time Series model using store as the case and the historical/actual line charts appear in the Charts viewer for each store. But only one prediction step is shown no matter how many prediction steps I select. I have tried this with an OLAP-based model and also tried a simple DMX query, all with the same result. Thank you in advance for any help with this. P Taylor The nature of auto-regression trees is that they can generate unstable predictions. Our algorithm alleviates this issue by truncating predictions that appear to be losing stability. Our heuristic for this may be too aggressive a ...Show All

• smargroth SQL Server time zone?

  I don't know what is going on, here's the error message, could someone please answer thanks Server Error in '/' Application. well obviously... but how to fix it is a little less obvious. been there done that, no one knows what that is over there, only told that I was shut out of the SQL database and no suggestions since. I know I'm not shut out of the database since I can upload other things besides new users to it, but if it is searching for something in the ASP.net program no one knows what it is. Thanks Did you try changing the code to pass that parameter Paul Randal - MSFT wrote: Did you try changing the code to pass that parameter ...Show All

• Wendell Wang Populate a variable

  During a dataflow - I like to populate a variable with True or False based on a value in one of the data records. How do I do this excercise  if I use a script - can someone provide me with simple script on how to populate one variable   Thanks heaps         If you retrieve your record using the Execute Sql Task... Double-click to edit properties. In the ResultSet drop down choose Single Row In the ResultSet tab map the result to a Variable In the constraint editor just put variable == 0 Is this what you are looking for Public Sub Main() MsgBox(Dts.Variables( "RutaFicheroCarga" ).Value) Dts.T ...Show All

• AdeptBlue RDA with Identity column.

  Hi Everyone: I am new to Mobile programming. I am now working on a mobile project. I encounter an issue when I sync the data: cause I can't modify the schema, so I have to use RDA instead of Merge replication on sql server 2005. However, There is an identiy column on each table I will pull them down to local mobile database. And I will use those identity columns to connect tables. Even worse, the photo's new name will combine the photoID which is an identity column. There would an issue, if i sync data, the photoID would be same on different local mobile databases. And there would be generate same identity value when users sync data. How can I avoid those issues If you have any good ideas, please help me out so that I can meet ...Show All

• Jean-Pierre Fouche "Update Statistics Task" in Maintenance Plan fails - SS 2005, SP2 CTP

  The "Update Statistics Task" of Maintenance Plan is failing with a strange error. I have a maintenance plan created on SQL Server 2005 SP2 CTP using windows xp account with administrative privileges. One of the steps.. "Update Statistics Task".. has been setup to update "All existing statistics" with scan type of "50% sampling" for "Tables and Views" is failing with the following error: Executing the query "UPDATE STATISTICS [NWRptUsr].[NW_ALL_ACT_CHRGS_V] WITH SAMPLE 50 PERCENT,NORECOMPUTE " failed with the following error: "Cannot create or update statistics on view "NWRptUsr.NW_ALL_ACT_CHRGS_V" because both FULLSCAN and NORECOMPUTE options are required.&q ...Show All

• Walter30140 SS A/S in front of Teradata

  Seems to me I heard a lot of announcements from Teradata the other day about working with MS A/S to better integrated into building cubes from Teradata source. I can't find any information on how this will be delivered. Is it a product, do I buy it, how much, it is just working to opitmize the OLE DB driver, can someone fill me in Analysis Services supports reading data from Teradata for second release already. Here is an article describing the way you use Teradata as data souce for AS2000 http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/teraas2k.mspx Analysis Services model is to use OLEDB or managed providers to connect to relational database systems. Not sure what exactly announced by T ...Show All

• BrianMcCulloch HelloWorld_CLR not sending messages anymore...........

  Hello, Yesterday I made the HelloWorld_CLR sample work and figured today I would create a simple windows service to immulate its functionality.  When this was not working I tried the sample again and it stopped working.  I have tried several things and nothing has worked.  Has anyone seen this before or have any ideas on how I can get it working again   I even tried removing SQL Server and its samples then reinstalling to give me a clean slate but that did not work.  I did not make any changes to the software nor did I make any changes to the database however the sample did so I need to make sure I can fix this incase it happens in development not to mention I need to continue development. The Client Que ...Show All

• fripper custom code in report

  hi friends i wrote following custom code in report to hide/unhide a textbox in report Public Function CheckVisibility(ByVal value As String) As Boolean If value.tostring().length > 0 Return False Else Return True End if End Function but i dont see this function when type in "code." in expression box am using VS2005 standard edition, is it a restriction for this version btw my textbox in "report footer". actually i tried for the textbox which is detail section also but no avail !! one more thing why cant i see function i created when type " Code. " i searched examples on net and i did exactly same as examples i found ! Custom code is not compiled until the report is published, so the ...Show All

• tchen777 indexing architechture

  OK: 1. after rebuilding indexes, shouldn't sp_updatestats and DBCC UPDATEUSAGE be run for best performance 2. What exactly are sp_updatestats and update usage doing It looks like (from BOL) that updating usage would be updating the IAM and the page free space, and updating stats would just update the index/row pointers. Indexes are rebuilt nightly where I am currently working, however, unallocated space is consistently negative. 3. rebuilding or defragging the indexes should defrag the tables, right As in, re-allocate free space depending on fillfactor... 4. for a reporting database, shouldn't the fillfactor be low That way, you would have fewer page splits during loading, and as far as querying, by the time you are done wit ...Show All

• scribework How can VB look something up in an SQL Table?

  How can a Visual Basic Application Lookup information from an SQL table database (all of this in the Code Window, not with the Application User seeing this). e.g.: Making a VB Application verify that the text in a TextBox is the same as the text in an SQL Table/Row (Like when verifying a password.) hi, your question is not that clear, to me... I seem to understand you need to "verify" a specified "text" edited in a text box is "valid" (meaning a corresponding entity in a specific table has been loaded with the corresponding value)... if this is the case, you have to open a connection to the desired database and perform a query against the specific table/view... i ...Show All