skyshock21's Q&A profile
SQL Server Date matching
I have done this twice now. I am sure I will do it again. I have a date dimension. Among other things the dimension contains columns for a meaningless id and raw date. If I want to translate a date to a the meaningless id for storage in a fact table, I use a look up component. All fine and dandy until I run the data flow and all of the look up's fail. Now what could be wrong with that I look at the redirected rows and for a split second think, ...Show All
Windows Forms Calculated Databind in a DateTimePicker
Hi all, I have a bindingsource / datagridview populated at run time from XML. I have a column in the datagrid with a number in it; I have a textbox bound (at runtime) to that column (that all works fine). What I am trying to do is have a datetimepicker display a date which is a specific date (actually an application user setting - my.settings.mydate) PLUS the number in the textbox - or a specific column from the selected row of the d ...Show All
SQL Server Regenerating Package ID programmatically
Hi, I built a small application that helps me create new packages by loading a template and modifying some parameters, and eventually save the updated package to a user defined location. This application uses the SSIS programming API. I know all the packages created this way from the same template will have the same package ID. Is there a way to regenerate the package ID programmatically I don't want to use dtutil.exe, but rather a nice pa ...Show All
Visual Studio Team System why I got different sizes of the *.msi file every time I compiling the setup project?
Hi,All I create a setup project in VS.net 2005. Every time I compile the project file xxx.sln. I got a xxx.msi file with different size with the previous one. Is there anyone know what's the problem Thanks. Hello, Can you please verify that this is still an issue If so, please let me know and I will have someone assigned to provide help. Thanks. ...Show All
Visual Studio Team System (Re)Build bugs with unit tests
There's an astounding number of cases where the unit testing framework doesn't properly build the units under test. For one of my test projects, it's nearly impossible to get a successful test run from the Test Manager or Test View due to build errors (out of date assemblies copied to test run directory). The only case that seems to always work is setting the unit tests project as the Startup project and hitting Run in the IDE. Are there a ...Show All
SQL Server OK button not working...
I am trying to get MSSQL Reporting Services working. I have used it before, but now I have the opportunity to get the software entrenched in my organization. I installed the app and it opens up, but when I try to create a new folder the software will not allow the OK choice. I can cancel, but I need to choose OK. I have installed the app, SP2, and a hotfix that is on the website. Help.... Thanks. The button pres ...Show All
Visual Studio Express Editions [C++ Express] Add Resource disabled?!
I downloaded Visual C++ 2005 Express Beta 1 last friday, but it seems that adding and compiling resources wasn't enabled in this version! Haven't had the time yet to try Beta 2, but is this enabled in this version or will it be enabled in future ! MS's "plan" here seems to disregard its (claimed) intended audience for the Express editions. MS uses language like "beginner", "get your feet wet", and ...Show All
Visual Studio vs appears to be hung when doing a 'get latest version'
each time i do a 'get latest version', the ide appears to be hung for several minutes. there is absolutely _no_ feedback about ss doing anything. the only indication of anything happening is my machines fan getting louder. when i click anywhere inside the ide, all open windows of the ide turn white. is there anything one can do to improve the performance in this area, or at least to get some kind of feedback about what is going on WM_THX thomas ...Show All
Visual C++ using a vb6 dll in vc++?
is it possible to use a vb6 dll in vc++ how do i access the properties(variables) in a vb6 dll (using let and get in vb6). for example i have 5 properties defined in the vb6 dll, 4 of which having write-access and 1 read-only access, how do i put values using c++ in those properties with write values and get the value of the property that has read-only access. Are properties and functions in a vb6 dll treated the same when used in c++ over ...Show All
Visual C++ how can start class wizard?
i am useing vc++2005 professional, and not find the class wizard as in vc++6.0. where can start class wizard ...Show All
SQL Server Database Mirroring vs SQL Server FailOver (Performance)
Hi there. I’m running some tests in a database with Mirroring and without Mirroring. As expected there is a performance hit using Database mirroring. The tests i’m running are just simple functions inserting and updating the database, and then counting the number of sucedeed inserts and updates in a time interval. My question here is: What if i use Sql Server failover mechanism I know that failover time will increase and management ...Show All
SQL Server SSIS Transactions
I've added a Data Flow Task to a Foreach Loop in a SSIS package. I want each execution of the data flow task to run in a separate transaction. I've tried setting the transaction mode of the data flow task to "required" and the loop to "supported". This works fine the first iteration of the loop. Then, the task fails with "Cannot enlist in transaction. Distributed transaction completed...". It seems that the data flow task commits the transactio ...Show All
Software Development for Windows Vista How to store more information using persistence/tracking service
Hi, I downloaded the examples of using Persistence and Tracking in ASP.NET from Tom Lake's blog and tested it. it works fine, but my question is where the eventOrder (int value) come from in UserEvent table it always is among of 5,18,31. One more question, how to store more information using persistence/tracking service for example, I want to save the user info, userID, so i need to add one more column to the table. I have to create my ow ...Show All
SQL Server About plug-in algorithms in SQL Server 2005
Hi, all here, I am having a question about plug-in algorithms in SQL Server 2005. Since we are able to implement our own algorithms in SQL Server 2005 analysis services architecture, so my question is: what benefits can to a great extent be achieved Like say, we are going to implement a plug-in algorithm, so what considerations should be concerned Thanks a lot in advance for any guidance and help. The plug-in infrastructure passes o ...Show All
Visual Studio Extending VS 2005 - Solution Explorer
I have a solution that builds 150+ dll's. Is there anyway to extend VS2005 so as the solution is being built each project will get a Green check-mark next to it if it built successfully. Thanks. Wow, I didn't remember this thread But yes in some moment I had the same problem and it was really heavy use VS or a command line in order to build so that I built BuildConsole.Net. VS very slow to load ...Show All
