Marlun's Q&A profile

• SQL Server File Metadata and the Foreach Loop Container

  Hello, I want to set up a Foreach loop container to loop through several flat files. I have a connection manager set up for individual flat files. The metadata for the files is all the same. They are fixed width files, and contain sixty five columns. I didn't see a place in the container properties to configure the metadata of the files. How can a Foreach Loop Container 'know' the metadata of the flat files that I want to loop through Thank you for your help! cdun2 If you are going to iterate through a number of files, you need t use a ForEach loop container that uses file enumerator . Then you need to create a single data flow with a single Flat file connection manager (using an exp ...Show All

• SQL Server How to get subscriptions from a shared schedule

  Hi I would like to know how to get the subscriptions from a shared schedule using the RS2005 API. What I did up to know is use the ListScheduleReports(ScheduleID) method to retreive the reports, and then use the ListSubscriptions(reportPath) method to get subscriptions. The problem with that is I cannot get only the subscription related to the shared schedule, I get all subscriptions for the report. When I query directly the Reporting Services Database with the following query, I get the right result: SELECT Schedule.ScheduleID , Subscriptions.SubscriptionID , Subscriptions.Description , Subscriptions.DeliveryExtension FROM ReportSchedule INNER JOIN Schedule ON ReportSchedule.ScheduleID = Schedule.ScheduleID INNER JOIN Subscription ...Show All

• Visual Studio Team System Finding specific method call rule

  Hi, I'm new with the FxCop app. I working with c# winxp env. I would like some help with a creation of some rules: 1) How to locate a specific function call in my code. for example: finding all the shows of the function "ShowMessage("hellow world");" I tried to use check(Method method), but it takes only the declaration of the functions. 2) I can find all the labels variable in my code, but not the content of them. for example: if I have: this.m_lable1.Text = "Hello World"; How can I get to the text field in it Thanks in advance. Dani. Hi, I trying to write a rule to determine whether the first argument of the function ( string ) is appear in a string ...Show All

• Visual Studio Express Editions Debugging running very slow

  While working on my program, I run the debug to test it out. It is running very slow. I saw somewhere where VB Express takes up a lot of RAM. My computer has 640 MB of RAM. Is it running slow because it is in debugging mode Because if this is how slow the actual program will run when I release it, I have a big problem on my hands. I don't think I'm doing anything overly complicated. For example, the main screen has 3 buttons. When I click on one of them, it takes several seconds (20 ) just to open a form with a DataGridView. Can anyone tell me if this is normal Thanks. John Here's a simple test. In Windows Explorer, go to the folder where your project is located and to the bin folder where the .exe ...Show All

• Software Development for Windows Vista Workflow in ASP .Net with sqlPersistence and sqlTracking

  1) I am getting this error randomly. In Method: Boolean GetCompletionInfo(System.Runtime.Serialization.FixupHolder, System.Runtime.Serialization.ObjectHolder ByRef, System.Object ByRef, Boolean) Error Message: The object with ID 488 implements the IObjectReference interface for which all dependencies cannot be resolved. The likely cause is two instances of IObjectReference that have a mutual dependency on each other. Stack Trace: at System.Runtime.Serialization.ObjectManager.GetCompletionInfo(FixupHolder fixup, ObjectHolder& holder, Object& member, Boolean bThrowIfMissing) at System.Runtime.Serialization.ObjectManager.CompleteObject(ObjectHolder holder, Boolean bObjectFullyComplete) at System.Runtime.Serialization.ObjectManager. ...Show All

• Visual Studio VSS Strategy

  Hi, I would like to request for some advise. I need to maintain source code in the following environment: development testing production Is there any best practise/well defined strategy that I can learn from ie, should these 3 environments exist with 1 database within the VSS or as 3 separate databases Currently, I am using VSS 6.0 Thank you Danny. You should create them as branches from the start. That is, create just one project called $/Development. Branch it to $/Testing, then branch that to $/Production. When it's time to promote code, use the Merge Branches feature. If you can find Doug Neumann's presentation from TechEd 2005 (google is failing me at the moment), yo ...Show All

• Windows Forms Mouse Leaving/Entering Bounds of Panel Covered in Other Controls?

  I have a panel on a form that is completely covered in other controls (and it isn't determined until runtime which and where those controls are on the panel). There is absolutely 0 space of the panel which is exposed. I need to find out when the mouse enters and leaves the bounds of this control. The MouseEnter and MouseLeave events don't work because for those to fire, the mouse has to be directly over the panel (and instead it is directly over the panel's controls). I've printed out the WndProc messages, and I noticed that sometimes WM_NOTIFY or WM_SETCURSOR messages are fired, but it is sporadic. It seems like if I move the mouse fast, those events don't ever get fired. Does anyone have a tip for how to handle som ...Show All

• SQL Server Permissions for Connecting to Reporting Services in Management Studio

  Hi, We have a user in the System Administrator and System User roles of 2005 SSRS. He is able to connect to the website (http://<servername>/Reports) and do whatever he needs to do. But, when he tries to connect to Reporting Services in Management Studio, he receives the following error: =================================== Cannot connect to <servername>. =================================== The machine could not be found (Microsoft.SqlServer.Management.UI.RSClient) ------------------------------ Program Location: at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.ParseServerName(String serverName) at Microsoft.SqlServer. ...Show All

• SQL Server Is it slipstreaming possible for SP2 ?

  Does anybody know anything about that Hi, no. See this post which still applies: http://blogs.msdn.com/euanga/archive/2006/04/27/584637.aspx HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Basic Why do some keyboard shortcuts not work.

  I can only get some shortcuts to work. For instance, I cannot assign a shortcut without also assigning it ctrl, shift or alt. On the same note, only ctrl and alt work. When using shift it gives an error. How do I get around this. I also want to use shortcuts like: S instead of say Ctrl+S. Also, how do I assign the Esc key to a shortcut. Thank you. Troy L. Operator '=' is not defined for types 'Char' and 'System.Windows.Forms.Keys'. Also, It will detect the keypress if I hold shift while pressing 's'. Maybe it is looking for Upper Chars Troy L ...Show All

• Visual Basic Problems installing Visual Studio 6.0 on Vista Ultimate

  I can not get Visual Studio 6.0 to install on Vista Ultimate. I am running setup.exe as Administrator and I get an errors saying "iviewers.dll was unable to register itself in the system registry". I'll reply... no matter what I do, I'll right click on setup.exe on the CD of Visual Studio and chose "Run as administrator" and always wind up with "RegCreateKey failed for \Interface\OLEViewerIViewerCLSID. Access is denied" OK is the only option which is followed by "DLLREgisterServer Failure. Access is denied" There is but one user on this machine and I am a member of the administrators group. Interesting point to note, setup.exe is not running memory, ...Show All

• Software Development for Windows Vista unable to invoke event thru reflection (in a Workflow application)

  Hello, I saw the below code on another thread to invoke an event thru reflection. When i try this, on the event object, i get a " TargetInvocationException ". (Note: I created the object implementing the event with "Assembly.CreateInstance". After CreateInstance, i cast down to a base class that implements FireEvent (and store in a hash). Each class is responsible to invoke its own event with a passed in eventName. this.getType() is virtual up to the concrete class with the public events. These concrete event objects, i pass into workflow as a ExternalDataExchangeService. It'd expect it's WF (Windows Workflow) that does a "new" on the event (thus instantiating it) at the time when of "AddServic ...Show All

• Windows Forms Binding to a Business Logic Layer

  Hi, The question is more for designers and architects. The question is about working with data, specifically about Binding to a Business Logic Layer. With introduction of typed datasets in .net 1.0 and especially in .net 2.0 I started to ask myself - isthat really necessary to create a class that is a mapping for a db table. I will explain what I mean. Take for example database pubs , table authors. With basically one click VS2005 creates for you a typed dataset, let's call it authorsDataSet , which incapsulates a complete object model of authorsDataTable , authorsDataRow and even multiple tables with their relationships. Notice that authorsDataRow IS an complete object model of an author. Besides, there is a authorsTableAdapte ...Show All

• SQL Server VSA for C#?

  Hi everyone, Ok, VSA is not able yet to offer us C#, but I wonder is there any way to call that language from there BTW, Microsoft is thinking over enable it in the next version Thansk for your time, HailTheBackMarket wrote: If I can't use C# in VSA, what's the point of using SSIS then I might as well write a C# program to perform the tasks myself. I don't really understand this comment. Its like saying "If I can't wear spectacles when I'm wearing a crash helmet, what's the point in riding a motorbike ". [OK, not a great analogy but you get the point ] SSIS is not a code generator, for C# or otherwise. It is possible to run .Net code within the SSIS runtime but this is not its primar ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XAP Importer

  Hi, I'm loading files from a windows form test application and I want to load XACT audio assets, but my idea was to ask the user only for the xap project filename, generate the files into a folder in run time and then simply load all the generated data according to the extensions. I've been doing MSBuilds for other standard importers, but I just can't find the names for the importer and the processor. My documentation shows N/A when it comes to XACT projects. Any idea    Thanks! Hi again, BuildXact did the job, but I kept thinking about those returning list of files and I seem to be unable to get them, I simply don't know how to write ...Show All