Answer Questions

• Saurabh_Mathur The parameter is incorrect. (Microsoft OLE DB Provider for Visual FoxPro) after SP1

  Having installed SP1, my SSIS packages using the OLE-DB Provider for Visual Foxpro no longer work. Using the latest version obtained from here: http://www.microsoft.com/downloads/details.aspx FamilyId=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en When attempting to create one SSIS from scratch, the message thrown is: "The parameter is incorrect. (Microsoft OLE DB Provider for Visual FoxPro)." The radio button option of "Copy data from one or more tables or views" and then selecting the "Next >" throw the error. It has to be the SP1 causing the problem because nothing else changed on the Server and everything was working fine prior to this. Microsoft, any feedback on this ...Show All

• ZergaKilla Selecting version of remote SQL instance into local variable?

  Hello all, I'm a bit new to SQL Server and T-SQL (my background is in DB2 ), so hoping you can help me with this. I'm writing a T-SQL script that's hopefully going to scan a bunch of SQL server instances and record the results. We've got a mix of SQL2K and SQL2K5 instances, and for part of my script I only want to run something if the remote instance is SQL2K. I'd tested this on my local PC with several instances created and it worked fine. When I try and run it for instances located on other servers it barfs . From what I've found from looking up the error message it looks like I've got myself a loopback -- but I don't know how to get around it - any ideas please DECLARE @tempdata TABLE (scratch sql_variant) DECLARE @debug tinyi ...Show All

• m_3ryan Data problem when publishing website

  I published my website directly to its production folder then opened Sql Express Management Studio and attached the ASPNETDB file to it in that folder. However, the location information displayed in the Databases window shows the file is actually mapped back to my development folder. Has anyone else encountered this problem Yes, I did verify that I selected the correct location. Okay, my mistake, it isn't actually mapped back to that file, it just names the database with the original path. Gotta wonder what genius thought that one up. ...Show All

• Frank S Anonymous Access from Pivot Table to OLAP 2005

  My asp-net web application connect to Analysis Services 2005 through Pivot Table client. To use anonymous access with AS2000 i used to add this property to the connection string of the pivot: "SSPI=anonymous". Which property give me the same thing with AS2005 Thanks! Thanks, it's working. But, if i set "Impersonation Level" property to Anonymous Is this the same of SSPI=anonymous Hi, The SSPI connection property is still there, so it should work the same. Are you getting an error David Botzenhart Hey David - good to hear from you ! Yes, you could still use SSPI=anonymous, but I really recommend in AS2005 to use standar ...Show All

• Grant Jenkins Report Server First Time Configuration: Provider Load Failure

  I'm trying to do the above using the Reporting Services Configuration Manager and I can't even connect. I get the error Provider Load Failure. Anyone got any pointers Can you please provide more detail about the solution. I am also facing this problem. Can anyone help me out on this Moving to RS forum. Mike Well I figured out my problem, the System PATH variable was missing C:\windows\system32\wbem I added it and rebooted and it works properly. It looks like reportingserviceswmi.dll depends on framedyn.dll which is located in the above path. Yes Well, there isn't much more to ...Show All

• Joseph Stalin Logical fragmentation

  Hi: when does a table not show any Logical fragmentation 1). Is it possible if the table has only non-clustered indexes and no clustered indexes, it wont show any logical fragmentation at all or shows less logical fragmentation . Also what is the difference between logical fragmentation and Physical fragmentation of a index .Is there actually something like a physical fragmentation for a index Thanks AK An example repro T-SQL Script would be helpful. Experts please comment. Logical fragmentation only applies to indexes (clustered or non-clustered). If the physical location of key orders from leaf level of an index is the same as physcial page order in the ...Show All

• samymelbourne Get the variable from Execute Process Task to C#

  Hi! I need help with some C# code. I have build a SSIS package with an Execute Process Task. I need to send dynamic variables in to my C# program so I thought it was a good idea to use the StandardInputVariable. How do I get the variable in my C# code Thanks Carl Your Main methods parameter collection what is the value and data type of User::test immediately before the execute process task starts executing is the value of this variable correct ctsand wrote: Thanks for your help. I tried to get the variable through the main method but it dont work, the only thing I got was the argument. My test code: static void Main(string[] args) { ...Show All

• Gurpreet Singh Gill How do I delibrately make a positive value a negative value

  I want to convert a positive value to a negative value. How do I do it... Wow that was a clever answer. Thanks Jarret. You can multiply that number by -1. Hope this helps. Jarret ...Show All

• Dee_dotnet_79 Convert Long to Datetime

  Hi. I need to convert a vb function into a user-defined function in a stored procedure. The vb function converts a long datatype into Date datatype. Here is the VB function: Function LongToTime(lTime As Long) As Date LongToTime = (lTime \ 10000) / 24 + ((lTime Mod 10000) \ 100) / 1440 + (lTime Mod 100) / 86400 End Function The function is used to convert a timestamp(hhmmss) into a more readable format. Would it be possible to create a function similar to this in SQL Thanks Wes hi there is no mod function in sql server you have to use % i think you can go ahead from here regards % (Modulo) Provides the remainder of one number divided by another. Syntax dividend % divi ...Show All

• Tryin2Bgood SQL 2005 Setup error of 1935

  I am trying to install the client tools on an XP machine. I already had to run the .NET 2.0 repair to get past an earlier problem. 3 components fail, the first one being VS. Here are the highlights of the summary.txt file. What can I do to resolve this TIA! Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) -------------------------------------------------------------------------------- Product : Visual Studio Integrated Development Environment 2005 Error : Error 1935.An error occurred during the installation of assembly 'Microsoft.VisualStudio.CommonIDE,Version="8.0.0.0",FileVersion="8.0.50727.42",PublicK ...Show All

• nicolajbor Sql Convert Date

  Hi... I'm with a problem here... I need to convert a date in a string like dd-mm-yyyy to yyyy-mm-dd in a SQL Query... How can i do that I need to use that in a query like this : Select CodeID, Name From Exams Where ExDate Between @Date1 And @Date2 This is urgent... someone help me please Urgent, yet in the wrong forum... Try the Transact-SQL forum. http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=85&SiteID=1 ...Show All

• Joannes Vermorel - MSP SP2 Report Builder and default save location

  Prior to SP2, when you clicked the save button it would take you to the root of Report Server. With SP2 (in old-style Report Manager mode, not Sharepoint integrated mode) it takes you to the /Models directory by default when you click save. Is there a way around this If I launch Report Builder via the following URL, it does fix the problem. But it doesn't let me pick table/matrix/chart. I would like to override the default save location AND be able to let the user pick table/matrix/chart: http://localhost/reportserver/reportbuilder/reportbuilder.application model=/Models/MyModel&savelocation= Suggestions The purpose of the SAVELOCATION parameter is to do what you describe above - to provide a default place where to sav ...Show All

• AAG how to transfer data from one sql server to another sql server

  Hi... Here is my doubt, 1. how can i transfer the data(Full Database) between two servers, the servers are in two different locations.... Is there any tool for do this..... some good ideas...... thanks The Copy Database Wizard of ssms lets you move or copy databases and their objects easily from one server to another.   steps: 1)Open sql server management studio 2) right click on the database you want to copy 3)select "tasks" 4)select "copy database" which is at the last. Regards Rajesh Basa If the database does not exist on the destination side and the transfer is a one time thing, I think you could just take offline (or detach) the ...Show All

• mxiong Why is SQL 2005 Express much slower than Developers Edition?

  I'm working on upgrading VB6-based application to employ SQL Server 2005 Express (it currently uses MSDE). I'm using the following connection string - Provider=SQLNCLI;Persist Security Info=False;User ID=my_user;Password=my_password;Initial Catalog=my_database;Data Source=my_pc;Packet Size=8000 The application runs exceedingly slow. As soon as I uninstall SQL Server 2005 Express edition and install SQL Server 2005 Developers edition speed increases in 5 to 10 times. Once I uninstall SQL Server 2005 Developers edition and install SQL Server 2005 Express edition the application's speed drops again. I have repeated this "cycle" several times: install express -> running slow -> removed express, installed developers -> running ...Show All

• Webbee dimension design

  In my telco cube, I want to analyze usage. Eg how much sms's a subscriber has sent. The fact table is completely denormalized and has lots of columns with different types of usage. For example, following columns occur: MO_VOI_PEAK MO_VOI_OFFPEAK MO_VOI_WEEK MO_VOI_WEEKEND Now the sum of these fields overlap. Evenings during the week are also offpeak... This is only an example. Different categories occur for different products, like voice, sms, mms and so on. And not all categories apply to all products. Eg, mms does not have the peak and offpeak distinction. Is it possible to put this into one dimension, without aggregating double I have already normalised the fact table, meaning tha ...Show All