SunFish7's Q&A profile

• SQL Server Changing destination database for SSIS Package

  Hi, I have a small problem. I've gone through the SSIS wizard and created a dtsx file which imports data from an access file into a SQL Server 2005 database. It has been set to delete existing rows and enable identity insert. I then edited the .dtsx package in SQL Server Management Studio and added an environment variable configuration to allow me to change the destination database. In the script which runs the dtsx, here is what I have (it's an x64 system, so hi have to use DTExec): "C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" /file e:\testimport.dtsx /set \Package.Connections[DestinationConnectionOLEDB].Properties[InitialCatalog];newdatabasename and here is the error I get: Description: T ...Show All

• .NET Development Browse image's pixel

  Hi, I have to get the value of each pixel of an image to do some comparaison. I used the class Bitmap and i loaded a 800x600 image. It takes me 20s to browse all pixel. (i used the method getpixel in a double for statement) I want to know if there is a class, or an other method to do this faster (around 1s would be perfect) Thanks David If you are doing this C# you could try a little Unsafe Image Processing . ...Show All

• Visual Studio 2008 (Pre-release) There is no binding named 'helloBinding' at system.serviceModel/bindings/wsHttpBinding. Invalid value for bindingConfiguration.

  Hi, I am not able to run http://localhost/group5/service.svc . I get the following configuration error. Configuration Error Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately. Parser Error Message: There is no binding named 'helloBinding' at system.serviceModel/bindings/wsHttpBinding. Invalid value for bindingConfiguration. Source Error: Line 5: <service Line 6: name="ProgrammingIndigo.HelloService"> Line 7: <endpoint Line 8: address="" Line 9: bindingConfiguration="helloBinding" binding="wsHttpBinding" Source File ...Show All

• .NET Development Expression Building - Access 2003

  Good Evening All: The Scenario: I am running a report from clients that have sales reported daily, weekly, monthly and so on. I need to put an extra calculated field in the form in Access that determines the next time the client needs to report data. Example: Client "A" sent in data today and they report every day. Client "B" sent in sales today, but reports weekly. I need to add an expression to determine if client A sends today and they are a daily reporter, then the calculated field would display the next day. Same for a client that reports on a weekly basis. The field would calculate if they sent data in today, then 7 days from now would be the next time they would need to send data. Here is what I have so ...Show All

• Visual Studio Express Editions FontStyle

  Here is what I am using Dim font_style As FontStyle = FontStyle.Regular and here is the errorr that I am getting Font 'Monotype Corsiva' does not support style 'Regular'. My question is how do I tell the program to load the font in it's default style Your code is very good. But it is unfortunately incompatible with Monotype Corsiva. All you can do is to write a Try/Catch block around "Dim new_font" and tell the user: "Sorry, no can do". Leaving them to guess that "corsiva" is, umm, Italian for cursive. The fortunes of the Monotype Company have been sagging for a while. Wonder why... ...Show All

• SQL Server Query Notification not fire all subscriptions...

  Hello all, We have encountered a weird problem; we have an application that registers to several queries for notification. For several weeks everything worked fine, any change to any query result in the database triggered the notification event, but since yesterday the mystery began… since yesterday not all changes triggers events , changing one table raise the notification event, changing the other doesn’t , all seems fine in the database , the application reports that all queries were registered successfully , in the subscription view in the database we can see that all the queries that the application subscribed to are present… What can be the problem Is it something in the database Can it be a problem in our application, ...Show All

• Visual Studio Express Editions Visual C++ 2005 express MFC

  Hello, i want to know if visual studio 2005 express have MFC, i ask because when a create a new proyect (Win32 Console Application) the option to add ATL and MFC common headre files are enables And how can i configure the program to add the MFC libraries in a executable 1) No - you cannot get a standalone MFC development kit 2) While you can try using the MFC header files and libraries from the earlier version of Visual C++ this is not a supported scenario and I do not guarantee that the code will even compile. If you need to use MFC with Visual C++ 2005 I would suggest getting a version of Visual C++ 2005 that includes MFC. ...Show All

• SQL Server OnError Script error

  I am using following script to combine all the System:ErrorDescription on OnError Dts.VariableDispenser.LockForRead( "ErrorCode" ) Dts.VariableDispenser.LockForRead( "ErrorDescription" ) Dts.VariableDispenser.LockForRead( "SourceName" ) Dts.VariableDispenser.LockOneForWrite( "Errordesc" , vars) Dts.VariableDispenser.GetVariables(vars) errNumber = CType (vars( "ErrorCode" ).Value, Integer ) errDescription = vars( "ErrorDescription" ).Value.ToString() errSource = vars( "SourceName" ).Value.ToString() errdesc = vars("Errordesc").Value.ToString() vars("Errordesc").Value = errdesc + errNumber.ToString() + vbNewLine + vbN ...Show All

• SQL Server Error message: Setup failed to configure the server

  Re: SQL Server 2000 Developer Edition Error message: Setup failed to configure the server I'm attempting to install SQL Server 2000 Developer Edition on a 2nd workstation in our area for development and practice with having this 2nd workstation as a "local" (test) SQL Server box. The install fails with the above mentioned message. (We have a database running in production on SQL Server 2000 and we need a place to simply copy the database and run tests on it) The target PC is running WInXP Pro-SP3 and has IIS installed, along with Visual Studio 2005 & .Net framework, etc. I downloaded it (via MSDN license) and accepted the defaults on the install. Any feedback is appreciated. Thanks, RLN ...Show All

• Visual C# software documentation?

  Anyone know of any resources that tells how to write a good software documentation I'm talking about "about this software", and "features of this software". ...Show All

• Visual Studio Team System Installing Team Foundation Server with Analysis Services on different server

  All, We are looking to install TFS on an existing OLTP SQL Server we have. This server does not have SQL Server Analysis Services installed on it as it's an OLTP database server not an OLAP database server. We have a dedicated SQL Server Analysis Server in our enviroment. Is there a way to install TFS using a different machine as the SQL Server Analysis Server so that I don't have to have SSAS installed on the SQL Server Thanks, Denny Cherry Senior DBA I asked our PM to look into this - I don't think we have a documented way of supporting this, but we're trying to find out if it "might work" or "definitely won't work"...stay tuned. ...Show All

• SQL Server Performance tuning issues

  I have built a solution which runs for two hours on a server with 4CPU 2GHz each and 2GB of RAM on windows 2000 server (CPU utilization almost 70% and almost out of RAM). I moved the two source databases and the solution to a new box runing 8 xeon's at 3GHz each and 16GB of RAM running widows 2003 server 32bit and it still runs for 2 hours (CPU utilization 10% and ample RAM left). I was expecting it to run much faster. So I started exploring the performance tuning features in SSIS and started tweaking the following: Control Flow: DefaultBufferMaxRows: Based on row size and buffer size, calculated the max rows. DefaultBufferSize: Set this to max 100MB DataFlow Destination: Rows Per Batch: Set this to equal to the numbe of ...Show All

• SQL Server Aggregations for Max Performance

  In the past, I blindly opted for MOLAP and set the percentage to 100% while designing the aggregations for my cubes. Of course, it rarely got to 100%, but I figured that was the best way to get the maximum performance for my cubes in terms of aggregations. Now fast forward to today, I decided to go through the wizard again because I've recently added a few measure groups and they currently do not have any aggregations right now. I went through each partition again, opted for MOLAP with 100%, and noticed that most of them went down in percentage. Why is that the case Perhaps more importantly, anything "wrong" with my approach of MOLAP 100% I assume that the only concern I have with doing so is the processing time of the cube ...Show All

• Visual Studio Changing selection in Crystal Reports

  First, I am using VS 2003 C#. I am starting to write some reports for my app and need to dynamically change the selection criteria on the Crystal Reports report. I have a Report defined, and then a Report Viewer accessing that report in a form. I need to change the "where" clause on the fly but I cant see how to do that with the documentation I have read. Can anyone give me an idea where to do this Whether it is in the Report Viewer, the form's C code, or where. Thanks ...Show All

• Visual C# Calling an unmanaged C-language function from C#

  I am attempting to call an unmanaged c-code function from C#. I have successfully called some functions in the dll that take strings as inputs. However I am having trouble with functions like those below that return data in string arrays. When I call the function there are no C# exceptions, but also no data returned. I think the problem is with the string arrays and the way they are defined in the C# declaration. Any suggestions would be very welcome. This is the c-code for the dll function: DLLEXPORT short WINAPI GETTUN( char *pTunFilter, /* 3-char testing program id */ short *iCount, /* actual number of tun ids returned */ char *pMore, /* flag indicating whether there is more data */ char **pp ...Show All