outcast1881's Q&A profile
SQL Server SSIS packages and MaximumErrorCount
1st question: 1. Create a new SSIS package 2. Add Script Task. Modify the script: Dts.TaskResult = Dts.Results.Failure 3. Run the package. Results into message:"Warning: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors". This is expected behaviour. 4. Add another Script task after the 1st Script Task and connect the tasks using "Failure" type of precedence constraint. 5. Run the script. The message is identical. There are now two tasks that set return value to Failure. Shouldn't there be two ...Show All
SQL Server How to create database having userid and password
Hi, I am using the sql server for creating the database. I want to create the database which is having userid and password. This I require since I wanted to restrict acces to database and also only authorise user to database can use the userid and password created at time of creation of database. So how can I create the database which is having userid and password See... that is how SQL Server Security Model works... SQL Server has two level security ... One at the serverl level (LOGIN) and one at the database Level (USER)... If u have access to server(LOGIN) it does not mean that u have access to all the databases... No... u just cant do anything if u have only login... these login has to have permission(added) to a dat ...Show All
Smart Device Development Regarding WM 5.0 PPC emulator
Hi, I need your help. I'm developing smart device appliations by using CF 1.0 on VS 2003. Now i installed WM 5.0 Pocket PC emulator sdk. But i could not select that emulator on VS 2003 which displays only Pocket PC 2003 emulator and device. How can i select WM 5.0 PPC emulator/device or how to add this in VS 2003 and EVC 4.0. Please send your suggestion or links. Thanx M. GANESAN ...Show All
SQL Server Problem with service of the SQL server 2005
Hello, I have a problem: I accede to the SQL server 2005 having installed the SQL server locally but it does not allow me to initiate, to stop nor to reinitiate the service, that only happens to my user, however with another one if it allows. the network is with work group, that podria to be thanks for its attention You need to log in to your computer as a member of the Windows Administrators group to start or stop the SQL Server service. When you are logged in as an administrator, you can use the SQL Server Configuration Manager tool to start and stop the service or change service startup properties. ...Show All
.NET Development XSLT Newline within Excel Cell ignored
I have an xslt file transforming an xml file to generate an Excel spreadsheet file. Everything works great except I am unable to insert a newline within an Excel cell. When I do it manually from within Excel using Alt-Enter, and save the file as xml, Excel has inserted " " . When I do the same in my xslt, Excel ignores it. Wraptext is on in the cell. I have tried wrapping it in <xsl:text> to no avail. <br> does not work either. I am running this with framework 1.1 - IIS 6 - IE 6 - all with latest service packs. Here is my current code. < xsl:for-each select = " Event " > < Row ss:AutoFitHeight = " 1 " > < Cell > < xsl:choose > < xsl:when test ...Show All
Visual Studio Tools for Office Loadbehaviour changes automatically from 3 to 2
Hi, I have a weird problem when deploying my Office Addin developed in VS2003. When installed the values for word, excel and pp. are all set to LoadBehaviour 3 as it should be. As soon as Iam starting on of the apps the values changes from 3 to 2 and therefore the addin doesn't come up. If Iam changing it back again it will be overwritten to to after the next attempt. Please help! many thanks in advance! Patrick hint: there is not .net 2.0 installed, as I could find a solution for a similiar problem in vs2005 Sounds like you've got an unhandle exception in the OnConnection startup and the apps are disabling you. http://blogs.msdn.com/eric_carter/archive/2005/02/01/365021.aspx ...Show All
.NET Development Datagridview Updates only the first record
I am working in vb 2005 and SQL Server 2005 Express. When the form is created (sub FormLoad) I manually create the connection the database, and fill the datagridview as well as manually created the databindings for several fields to display additional information from the database table. When the form loads everything populates perfectly (datagridview fills, and the corresponding fields for the record are displayed in the bound text boxes). As I click through the datagridview, each of the corresponding textboxes are filled with the appropriate data from the newly selected record. So far, so good. The problem comes when I attempt to update the dataset / current record by changing a value in one of the bound text boxes. Regard ...Show All
SQL Server Derived Column / Change date format
Hi, Is there a way using a derived column transformation to change the format of the date eg: The input flat file's date is in yyyy/mm/dd and i need to convert / change this to yyyy/dd/mm Is this possible Thanks in advance, Slash. .. would work because it is not really a date is it It is just a string. Worth bearing in mind since display of dates is really a client issue not a SSIS/Server issue, unless you are taking a string and converting to a date type. Then SSIS will use the "client" as in user account settings that the process runs under when interpreting the string. ...Show All
Visual C# Object class and value data type
Hi All, I cheked the Object.ToString method in MSDN this morning. It says that This method can be overridden in a derived class to return values that are meaningful for that type.For example, the base data types, such as Int32 , implement ToString so that it returns the string form of the value that the object represents... After reading these, I've two questions. Q1)Can Int32 be considered as a class I checked the Int32 definition. It's a struct that implements the following interfaces. public struct Int32 : IComparable, IFormattable, IConvertible, IComparable< int >, IEquatable< int > Q2)How can the ToString() be overridden in the Int32 since it's not derived from Object class (based on the above definition) I kn ...Show All
Visual Studio 2008 (Pre-release) How to transfer known types information?
Hi All, I have a WCF service (let's call it main service). Multiple instances of this service can work on different computers in a network. I have another WCF service (load balancer) which performs load balancing between main service's instances. All clients' requests come to load balancer and are redirected to main service's instances. Load balancer's interface mimics the interface of the main service. But main service(s) also expose dynamic list of serializable types as Known types. These types are visible for load balancer but I need to make them visible for it's clients too. So I need to add them as load balancer's known types. As I said, the list of types is dynamic, I don't know these types in advance. It looks like I ...Show All
SQL Server SQL Server 2005 JDBC Driver Output Parameter/Result Set issue
I'm having an issue with the JDBC driver when I execute a stored procedure that both has a return value and also returns a result set. If I attempt to retrieve the return value (registered as an output parameter) after I execute the stored procedure, then any subsequent attempts to retrieve the result set always return null. Is this by design If I use the result set first and then later get the return value that works; however, in my situation I need to first check the return value before I work on the result set. Am I'm I doing something wrong Code: CallableStatement cs = connection.prepareCall("{ = call spGetCustomer( , ) }"); cs.registerOutputParameter(1, Types.INTEGER); cs.setString(2,"blahblahblah"); cs.setB ...Show All
Windows Forms Web Browser
I am developing an application and I have a couple web browser questions. In my browser, I would like pop-ups to open in a new browser from my app. instead of poping up in Internet Explorer. Also, I would like the user to be able to type an address i.e. www.microsoft.com , and hit enter and it will show up instead of having to hit go....... Thank you so much for all of your help! Hi,sk8terboi For how to pop up a new browser from your app instead of poping up in IE,you can refer the example at: http://www.codeproject.com/csharp/ExtendedWebBrowser.asp And for your second question,you just have to handle the KeyDown event of the address textbox,for example: private void addressToolStripTex ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Getting the Device and Content Manager
Now that things have changed with the Device and the addition of the Content Manager I have no clue of the proper way to get access to these in my GameComponents... Right now I am passing them in as arguments, but this is getting kind of rediculous. Is there a more correct way to go about getting references to these objects I searched the help but all the examples use the Game class and thus have direct access to them. Thanks, John For the graphics device, you can do what you did in Beta1. game.Services.GetService(typeof(IGraphicsDeviceService)). The content manager doesn't register itself as a service by default as you can just create one as you need in your components. If you are wanting to share resources across c ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Got a Feature Suggestion for the Next Version of the XNA Framework?
Cross posted from: http://blogs.msdn.com/xna/archive/2006/12/03/got-a-feature-suggestion-for-the-next-version-of-xna-game-studio-express.aspx We're putting the final touches on our first release of XNA Game Studio Express and our launch on December 11 th is less than three weeks away! Many of the team’s members have started to think about features that could be implemented in versions of XNA Game Studio Express down the road. While the team has ideas about things we’d like to do, we rely on you to tell us about the things you’re interested in or that you’d like us to change in future releases of the Product. The best way to share this information with us is by using Microsoft Connect . If you’re unfamiliar with Microsoft Connect, plea ...Show All
Software Development for Windows Vista Filter the sqltrackingquery by ActivityName / ActivityType
Hi, Is there any way to filter activitytrackingrecords by Activity Name or the type of Activity in sqltrackingquery e.g I want to get the list of activitytrackingrecords of all code actities of workflow Instance 'x' Thanks I am not sure you can write such a SQL Query but you can surely write your own custom tracking profile which can help you have more control f what is being tracked. THere you can specify what exactly you need to track. Take a look here: http://msdn2.microsoft.com/en-us/library/ms742042.aspx http://msdn2.microsoft.com/en-us/library/ms742184.aspx Thanks, Kushal. ...Show All