Ryan_H's Q&A profile

• SQL Server Reusability & SSIS - issues they do not write in books about

  I have a simple requirement: Each package needs to have Error Handling - which needs to Execute a SQL statement. It's the same Stored Proc - where each package passes in its ID. Ok - I get that part about creating a custom task and so on for reusabilty. But - lets say that after deploying this task in 20 packages - I need to change the name of the Stored Proc. What is going to happen in that case Correct me if I'm wrong - but after deploying the new version of the custom task - do I need to go to each package and update the reference to new version Allrite - another scenario: We have a common Script to extract data from XML which works with X number of packages (currently x=5). So how do you make this script reusable in a way that w ...Show All

• Visual Studio 2008 (Pre-release) Media Element Will Not Play. (And general installation issues)

  I tracked the error down with the on failed error, and I THINK this is ther error: Insufficient memory to continue the execution of the program. I can only say think so because the routed events confuse me somewhat. lester - MSFT wrote: If media element is not playing then its likely that your media player is an older version. v10 or higner is needed Wrong, I had WMP 11 before and then MediaElement didn't work, then i rolled back to v10(it's actually better than 11 anyway) and now it works perfect. ...Show All

• SQL Server How to fit 16 hours of upgrade work into 2?

  How to fit 16 hours of upgrade work into 2 A client of mine is trying to upgrade their SQL Server box. They are on SQL 2000 now and the new box will be SQL 2000 as well. Before you ask, they don’t want to go to SQL 2005 for licensing issues (i.e. cost). The problem I’m having is that in addition to moving the database they need to add an update field (smalldatetime) with an index. Adding the new field and index to each table is taking around 16 hours on the new box. This client is an online retail shop and they are completely dependant on SQL being up. The have given me a 2-3 hour window to make the move. So how do I get the database moved and updated in 2-3 hours This is what I have done so far: Argue ...Show All

• Visual C++ CString assignment operator causes memory exception

  I compiled VC++ 6.0 code with VC++.NET 2003/2005 beta and both causes a memory exception with CString assignment. My code looks like the following: CString szFileName = g_pGlobal->m_szAppPath; where g_pGlobal is a pointer to an object with global scope. The crash occurs if the assignment is done outside of the object instance itself. Quick Watch shows all CString members of that object are Bad Ptrs! I don't get it. Hi Brian, I tried to repro the scenario as close as I could, with a quick test app and had no problems. But the crash is the CString assignment still occurs in my project. I guess I will use my fix, that is making the CString member as static, and the crash will still remain a myst ...Show All

• SQL Server Precedence puzzle

  Hello folks, I have probably a dumb newbie question but I can't find the answer anywhere. On my Control Flow design pane I have two objects: a SQL task object and a Data flow task object. The first 'points' to the second. From my digging I believed that by indicating with the arrow from 1 to 2 that 1 would execute to finish before 2 was started. My SQL taks is to truncate a table to receive the new data coming from the data flow task object. Instead 2 executes first and then 1. You can imagine producing an empty table was not my goal for this package. Can anybody give me a clue Thanks.... Jim Are you sure they are executed in this order How do you determine this I would try setting pre-e ...Show All

• Visual C# about driver in computer

  hi How i can detected if any drive in my computer exist on Network or in my Computer for example when i add drive from Map Network drive suppose i add drive g: i can't to to distinguish between this drive and another drive in my computer are there any thing refere if this drive from network thank you very much ...Show All

• Visual C# How do you modify windows form control's properties from other classes?

  I am trying to make it so when a button is clicked the text on that button will change to something else using a method from a different class. I can't quite get it. This is what I have so far: using System; using System.Windows.Forms; public class Form1 : Form { public Button button1; // Windows Form Designer generated code here... } private void button1_Click(object sender, EventArgs e) { // I want the method to be called here } And here is the class that I want the method in: using System; using System.Windows.Forms; public class Change { public void ChangeText() { // How would I be able to modify the button and its properties } } Can someone please help me with this Thanks. T ...Show All

• Visual Studio Express Editions thx

  I cants eem to get the datetime things to work. I want to be able to display a label with Day of week, day of month, month, year, hour, min, am/pm Any advice appreciated. I cnat find any samples on the forums or microsoft or web. I get this to work for the time at least Public Class Form1 Private Sub Timer1_Tick( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick Label1.Text = Now.ToShortTimeString End Sub Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Timer1.Interval = 1000 Timer1.Start() End Sub End Class I had tried the system and form ...Show All

• Visual Studio 2008 (Pre-release) Bitmaps & the Adorner layer

  I have wired up an MFC app to display a WPF panel as a view using the HwndSource mechanism. It all works fine, except nothing on the adorner layer (which I use extensively) is visible. Is this a limitation of the integration technique or is there some way I can see adorners Thanks, Jeremy Okay, after a bit of flailing, I determined that adorners are working just fine in this context. The problem was that certain dependency properties were tied to config file settings which did not exist in the context of this MFC host application, and therefore the adorners had an opacity of zero, causing them to be invisible. Thanks to all who responded. However, I have another question which is tangentially rel ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirextX Version?

  The Readme file notes that DirectX Runtime XNA Game Studio Express Setup installs the current version of the DirectX runtime. The runtime is required in order to use the XNA Framework game API. Does this mean XNA stuido is using the October runtime and if I install the october SDK is it going to break anything Question still remains. Which version of the DirectX runtime and SDK is the Beta 2 running under is it safe to install just the october SDK with the Beta 2 noticed that under the tool options with the beta 2 that XACT is installed as well, so is this XACT from August or October ...Show All

• SQL Server Any ideas how to connect to an Informix DB?

  I need to use the an OLE DB Provider to create a Linked Server using a ODBC-Connection (Informix). I know that I cannot see many things in the Providers drop-down list. Has anyone created a linked server like this one I mean SQL 2005 (Standard Edition) x64 and Informix. 10x in advance. Of course I'll provide any useful news as soon as they will arive. I want this solved and shared with the rest of us, so we don't have to be at Microsoft's mercy; or any other giant for that matter ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Ball rolling + Collision in XNA (Sphere 2 Polygon I guess)

  hi all, I’m writing a little demo this days in XNA. I have a tiled landscape ( just 40x40 3d tiles) and I want my ball to roll and move across the landscape. The problem is the same that Latest metroid games (Prime and echoes) that appeared in Game cube when Samus morphed into a ball and was rolling around. I guess I should get the tiles that are occupied by the ball and then make a sphere polygon test or somehitng like this. I would like to apply physics to the ball too. I’m in no way experienced in this and I would like to know if there exist any good XNA library or else to handle physics/collisions for me. Thanks in advance, HexDump. I looked around, and havn't found any go ...Show All

• SQL Server Writing MDF to SQL Database

  Hi, I've been searching the internet for hours and the code i'm finding is just not what i'm wanting to do. Heres the story, I have a database file "MyDatabaseFile.mdf" I am making a form when you click a button I want it to create the "MyDatabaseFile.mdf" in MS SQL Server. Is this possible if so how I it something like "CREATE DATABASE MYNAME ". I jsut want the MDF file i dont want the log file inserting or anything. Is there any tools out there that anybody can recommend that will help me with T-SQL   Cheers, Rob Hi, MDFs cannot be created as a single files. A MDF always comes with a LDF files, which keep the log information and is responsible for transactional concistency. If you create a database, the da ...Show All

• Visual Studio Problems going from the .Net 1.1 sdk to 2.0 with VS 2003

  I am trying to learn to use the WMI .Net api, and here is a small c# program I got from the MS site I can't compile: Code: using System; using System.Management; // This example demonstrates how to perform a synchronous instance enumeration. public class EnumerateInstances { public static int Main(string[] args) { // Build a query for enumeration of Win32_Environment instances SelectQuery query = new SelectQuery("Win32_Environment"); // Instantiate an object searcher with this query ManagementObjectSearcher searcher = new ManagementObjectSearcher(query); // Call Get() to retrieve the collection of objects and loop through it foreach (ManagementBaseObject envVar in searcher.Get()) ...Show All

• .NET Development .NET and security - Why so complicated?

  Lets say you write a nice .NET 2.0 windows form application. myapp.exe is it's name, and it references mydata.dll which is a class library that has a few classes and a user control in it. It is also written in .NET How would one address the following issues 1) ANYONE can take mydata.dll, open up VS.NET and reference it and use the controls and classes inside 2) ANYONE can simply decompile the IL from both the exe and dll back to almost original source code Now I know all about obfuscators, and people love to recommend them for such tasks like # 2 above, but how many people actually have used an obfuscator successfuly I have used the community edition one that is packaged with Visual Studio, however its rather limited, ha ...Show All