Juan T. Llibre's Q&A profile

• SQL Server Migration SSIS in msdb to other server

  I depolyed several package in a server A msdb in some logical folders E.g. msdb\Task1\package1 msdb\Task2\package2 msdb\Task3\package3 I would like to migrate the package to other server B and keep the logical folders tree. I know I can reploy the packages in B and move them to the logical folders tree one by one, it is too slow. Is there any fast method to migrate the package and keeping the tree Thanks. Sure, move the tables directly. Should work. You can use a package to move rows in the sysdtspackagefolders90 and sysdtspackages90 tables. Move the packagefolders rows first to retain RI. Be careful that there aren't identically named folders or packages, it could ge ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. D3DERR_NOTAVAILABLE while build of first example in help how to do

  I used to code in pascal, cobol, assembly, basic, etc, but not C. From: Your First Game: Microsoft XNA Game Studio Express in 2D following along and doing the first build, I get the error above. I did not think I was calling the 3d engine only the 2d. I cannot find any help on the error, where to look, etc, except what is in the error window when you cursor over it. I cannot figure out how to copy the error in that popup window to look at it further. I know some dislike nubies, but please help if you know the answer. Its disheartening to type in only 6 lines of code and not be able to debug it! To say the least. Thanks OH OH OH, I figured out how to copy the error: Error 1 Building content threw InvalidOperationExcept ...Show All

• Visual Studio Team System Connection pool

  could you please help me with this,I used a load of 750 user,and choosed Connection Pool Size and made it 50...i was getting a red cross on the counter 'avg Connection Wait Time' then when i made the connection pool to 800,now this time i got a red cross on Processor time .Why So What is the ideal thing to use "Connection pool/per user" and the ideal values to be set. Can we have a list of all the Threshold values that is internally set in vsts,as we do get errors on the graph as 'exceeded the threshold value of -". Thanks For the connection pool, I would recommend that you either use "Connection Per User" or a ratio more like 2 to 4 users per connection, so perhaps a Con ...Show All

• Visual Basic Crystal Report help!!!! PLEASE

  Okay, I am currently making a mailing letter in Crystal Report that will be auto filled by my database. Here is what I am running into. I have set my database up to collect and store the indivuals first name and last name in seperate fields. What I am trying to do is make it to where I don't have alot of spaces whenever I between my FirstName and LastName in the crystal report. For example: (This is what I want it to look like) Joe Dirt 12345 Summit Drive Test, GA 789456 Dear Joe Dirt, (This is what I DON'T want it to look like) Joe Dirt 12345 Summit Drive Test , GA 789456 Dear Joe Dirt, ** My fields in in Crystal Report have to be so big because I want every name to fit inside them. Is th ...Show All

• SQL Server Join order considerations in SQL Server (2005)

  I'm doing a bit of research on join order in terms of how it affects performance in SQL Server (specifically 2005). Can someone point me to some sites that do a good job of explaining this, or, can you give me a good overview of the topic As far as performance goes, I think you will be fine regardless of your join order for the most part. In outer joins (think of a LEFT OUTER JOIN) the order of your tables will matter because the result set would be different depending on which table is the outer and which table is the inner. That is not so much a performance consideration as it is a results consideration. One motto I always live by is to try it and see. So you can get a lot of replies with links, but ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Problem with initial Run.

  Oh great wise XNA gurus... I need your professional help with a problem I am having with the initial run/debug of my starter game. I'm follow the instructions in the "Create your first game tutorial" and went ahead and added my first sprite. When I build solution and run the .exe it brings up an error and I go ahead and debug the problem. This is what it shows: "An unhandled exception of type 'Microsoft.Xna.Framework.Components.NoSuitableGraphicsDeviceException' occurred in Microsoft.Xna.Framework.Game.dllAdditional information: Could not find a Direct3D device compatible with the current device preferences." I tried reinstalling DirectX, rebooting still nothing. Am I doing something wrong Or did I skip a step in the compilation or install ...Show All

• Windows Live Developer Forums Reduce detail of the map tiles?

  Is there a way to say remove some of the extra detail at zoomed in levels ex: roads, city names etc. I'm assuming you want to remove them from Road/Hybrid view   If thats the case, you'll need to mapcrunch your own tiles on top of the map as those names are part of the VE imagery and cannot be dynamically removed.  Otherwise I'd recommend sticking with aerial mode (which doesn't have road names nor city names). ...Show All

• Visual Studio 2008 (Pre-release) SOAP MessageID and basicHttpBinding

  Is it obligatory for framework to create instance of MessageID at SOAP Header For basicHttpBindigng I got: message.Headers.MessageId => null For wsHttpBindigng it's not case. The MessageID SOAP header is only required for WS-Addressing. BasicHttpBinding does not use WS-Addressing, and therefore you are not getting a MessageID (the HTTP request-reply pair is what correlates the messages). ...Show All

• Visual Studio Express Editions Question about database and C# commands

  I’m making a program that uses a SQL Express database and i have a table called Utilizador (user) and it’s primary key ID_Utilizador wich is an automatic int counter (1-2-3....etc), and i cant alter its value. What i need is to find a way in C# 2005 Express to know the next ID number that the next row to be inserted will have without knowing the ID number of the last row to be inserted. Maybe there is a command for this but i cant find it. Regards Rui hi, the best way is to ignore the ID field in your insert statment , the database will generate this record for you, to set the ID field yourself in insert statment could generate a bug, if your database has many clients lets say 2 of them wan ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA framework for non C#

  One of the great advantages of the .NET framework is that developers can work on the same project in different programming languages. As I'm reading about XNA, it seems that this will not be possible with the XNA framework. Will the only programming language that has access to the XNA framework be C# Have to disagree with you. I know plenty of indie developers who would jump at the chance to using the XNA Framework with C# (myself included). As far as non-Managed C++ and the XNA Framework - what's the point My understanding is that it's for development .NET code, not non-Managed C++. My $.02 - if it only supports C#, I'll still happily use it. I'll be waiting (somewhat) patiently to get my hands on it. ...Show All

• SQL Server Calling commands from the cmd prompt

  I have a series of commands that I need to run which decrypt, unzip, and rename They are all one line commands when entered on the cmd prompt, is there an easy way to do this in ssis or should i write an exe and call them from there Thanks I'm using gzip to decompress files. the command I'd like to run is gzip -dc filetounzip > filenametosaveto I'm having no problem running everything before the ">" character. This normally pipes the output to location filetosave to.  Without the filenametosave to it dumps the output to the standard out. I tried to put the filenametosave to in a variable in the standardoutputvariable property w/ no avail. The reason I'm using gzip is because I'm unzipping a .gz ...Show All

• Visual C# Strings

  Hi there I am trying to connect to a SQL database, the default installation of SQL Express installed by Visual Studio Professional. Let me first say I'm coming from a VB6 background, so I know diddly squat about C#. You can consider me a classic case of VDU (Very Dumb User). My main problem is that I am trying to connect to the sql server by using a connectionstring. I am setting the value of the connection string as follows ConnecString = @"Data Source=[GD-MOBILE\SQLEXPRESS];Initial Catalog=PRISM_Test;Integrated Security=true" My problem is that the single backslash is converted to 2 backslashes, and I think this is causing the problem. How do I get just one backslash in there Thanks Carlos It ...Show All

• Windows Forms I have a bug with a deployment project, help :(

  Hi, I got that error when I tried to setup an application I made using csharp where it works on data from sql sever db. But on my own machine the setup package works fine, I ma stuck on that bug and I tried all ways, I hope some one help me :( Unable to get installer types in the 'app-path'+'programname.exe' assembly --> unable to load one or more of the requested types. Retrieve the loaderExceptions property for more information. I'm guessing here, but I suspect this is in your custom action that's an Installer class. The most likely reason is that your assembly is dependent on other assemblies that can't be located. They are probably in the GAC on your system but not on the other target systems. ...Show All

• Community Chat KnowledgeNavigator

    KnowledgeNavigator is a Dot Net based knowledge abstraction tool using an Acess database. It is a set of organized categories and documents that you, the user define. The categories and documents created by you and are displayed as if they are in your computer file system except they are not. These documents and categories are contained in one central and transportable database, a database that you can send to friends and share with them or a database that contains all the documentation for a project, or better a set of in-depth topic on wine or even recipes. You can create Categories and subcategories of your own chosing and ogranization. New databases can be created and selected. KnowledgeNavigator will ...Show All

• Internet Explorer Development Interacting w/tabs in IE7

  Is there a recommended way of (a) enumerating open tabs in an existing IE7 window, (b) figuring out which tab is active, and/or (c) setting a specific tab to be active I am working with a .NET forms applications, not an IE7 extension. The only way I've found to enumerate tabs is to step through the HWND hierarchy and look for windows of class TabWindowClass, but this seems awkward and doesn't let me do (b) or (c). If this is the best way to interact with tabs, does someone have a nice clean example of how to do this in a reasonably robust way, how to get IWebBrowser2 interfaces to individual tabs, activate tabs, etc. Thanks for any tips you have! -Dan http://research.microsoft.com/~dan (Interestingly, MSDN forums _insis ...Show All