orlop's Q&A profile

• SQL Server Import Fixed-width data with DSNs

  Ok, so I've been playing around with SQL Server 2005 64-bit Dev Edition in readiness to phase out my existing SQL 2000 box. I've been having difficulty with importing fixed-width text data with SSIS. To explain, we use a linux based ERP system which is stored in a non-standard, encrypted flat-file format. So, each evening, I have a cron job spin off some shell scripts that use the ERP's report tool dump all of the relevant databases I need into a fixed-width format text file. The ERP platform also has a db layout report which is also in text format, I use this file (mangle it with VB first) and dump it back out into the format used to make a DSN file. DSN connector file (dbname.dsn) [ODBC] DRIVER=Microsoft Text Driver (*.txt; *.csv) UI ...Show All

• SQL Server Refreshing datasets at design time.

  Hi, I am very new to reporting services so please forgive my ignorance. I am having trouble refreshing datasets in the Visual Studio IDE. I am creating local reports using the windows report viewer control. I use stored procedures as the source for the datasets. I can set up a report fine but if I go back and add or delete a column from the stored procedure it does not seem to reflect throughout the solution (specifically in the XSD and RDLC files). Refresh seems to do nothing. If I use the dataset "configure" wizard it does recognize my new column structure but it still does not refresh (or rebuild) the dataset. I can manually edit the dataset and remove columns but that does not seem to be a very maintainable option. Mo ...Show All

• Visual Studio Team System Changing State according to a field's value

  All, I have 'bug' work items which are in a 'Resolved' state. I would like to change the state according to another field's value, for example if the value of 'Testing' becomes 'test failed', i would like to change the state to active automatically. I had hoped to achieve it with something like this: <FIELD name="State" refname="System.State" type="String" reportable="dimension"> <HELPTEXT>The workflow state of the bug</HELPTEXT> <WHEN field="MyCompany.WorkItems.Testing" value="Test Failed"> <COPY from="value" value="Active"/> </WHEN> </FIELD> ...but there are constraints on the System.State field ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Custom Directx Maya Extention

  Hi Guys, Currently I am using directx and Maya to develop my game, and I am trying to custom the maya exporter of dx, (e.g. in my case, I try to not export every global variable in .fx file which associate with a .x as a effectinstance parameter in .x file, and want to select some one by user when export the whole mesh) and another need is I am very pleased by scenemanger example that offered in dx, and I am trying to custom the maya extension so let it could export some .x file like scene.x, but I have no exp of writing maya plugins, and do not understand the source code of directx extension in the DX SDK, any one could outline the structure of it, or told me a quick way to sort out my problem, or offer some good resources to do my job ...Show All

• Software Development for Windows Vista DirectShow Memory Leaks?

  I am trying to complete a media player by DirectShow.To have more functions, I add filter to graph one by one And Release the objects when the it opens next file.But the memory is increases when opens next file,especially when it opens WMV/WMA file,which it opens by DMO.I have release all the objects and interfaces but the problem remains.I am very frustrated!Is there any ways to solve the problem My guess would be there is still something you are failing to release. Are you using smart pointers You do release the graph object itself ...Show All

• Visual Studio Team System Notification Service : Any Success stories

  Hi All, if anybody successfully subscribed for the TFS events like BranchMovedEvent NodeCreatedEvent NodePropertiesChangedEvent NodeRenamedEvent NodesDeletedEvent ProjectCreatedEvent ProjectDeletedEvent the events which i mentioned above won't have the schemas right now..and the same i have created using XSD tool and using TFSReg command i have registered and subscribed the command using Bissubscribe but i am not getting email... please ref my post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1084653&SiteID=1 if any one have the perfect subscription, please share me the COMPLETE PROCEDURE TO DO THE SAME (from top to bottom) Thanks, Kathir Hi Naren, Thanks for your inputs. R ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Performance Question

  I have had a question recently related to instancing and batching draw calls. I would like to know which way is generally the fastest. I have seen the shader instancing example in the dx sdk however i was not totally wowed by it since it the vertex declaration required an extra tex coord that simply acted as an index into the vertex buffer for transforms etc. I relaize the speed gain was nice though. I was wondering if you have a single vertex buffer with one instance of the model data inside of it where is the common performance hit if i want to draw a hundred cars is it in the drawindexed primitive call or the setstreamsource call I have had some people tell me to just use one vertex buffer and batch the models to use on draw c ...Show All

• Windows Forms Need help changing AxWebBrowser (COM) code to .NET Web Browser!

  object obj = axWebBrowser1.GetOcx(); IOleObject oc = obj as IOleObject; oc.SetClientSite(this); How can I make this code work with the .NET 2.0 Web Browser Control Never mind - I figured it out - this is all part of a .NET Browser effort. Email if you want a copy of the latest beta - mateuszrajca{at}gmail.com ~Matt ...Show All

• Software Development for Windows Vista Missing Persistence Schema RC2

  I have installed the most recent release canidate for windows workflow. I went to add the default persistence service to my workflow and discovered that the schema files do not exist on my computer (in fact in the C:\WINDOWS\WinFX\v3.0 directory, there are only two folders WinFX Runtime Components 3.0 - Beta 2 and WPF and both are empty). I have installed the RC on 3 machines, and all three are the same, so I don't feel reinstalling will fix the problem. I have tried the installer that came with the labs (in C:\Windows Workflow Foundation\Labs\SQL_Scripts\Lab03 I ran CreateDatabaseObjects.cmd) and the installer did not work. I got "0sql is not recognized as an internal or external command, operable program or batch file." Does an ...Show All

• SQL Server Moving reports backward from RS2005 to RS2000

  Is there a nice way to get reports from an RS2005 project into an RS2000 project I know this sounds like an odd request but I have built reports in RS2005 that need to be deployed to a server with only 2000 on it. I don't really want to have to go in and re-draw all those reports. Any ideas would be most appreciated! Thanks, Eva YAY!!!! Thank you, thank you, thank you! for taking the time to post that link. It worked like a charm and I just saved countless hours of work when this literally took seconds a report. You honest, really, and truly made my day Eva ...Show All

• Visual Basic how to register components so they could be used in IE ?

  hello i want to register an UserControll in the system so it could be used in Internet Explorer , like Flash player or Media Player. is there any guide about it thanks for help Hi, I guess you want to host a .NET WinForms User Control in IE If so then here is a sample: http://geertverhoeven.blogspot.com/2006/12/my-first-net-applet.html . Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• SQL Server How to improve package stability

  I submit a SSIS package with data flow task by DTEXEC command on a W2k3 SP4 server installed SQL2005 EE SP1 several time. The package sometimes finish the task successfully but sometimes failed. I would like to know how to improve the stability of running package. The server is not busy for other tasks. The resource should enough to run my task. It is strange. Thanks. Three steps to improve package stability and speed (for my particular situation) on an x64 SSIS (version 2153) server not also running SQL server on the same machine. 1. Ensure proper network adapter configuration. Having a chatty network adapter can slow down SSIS packages dramatically. We modified the network adator fr ...Show All

• SQL Server How to attach mdf files which are residing on other machine

  SQL Server 2005 and the related databases are on one server. Due to space constraints I have to move one of the database(mdf & ldf) to second server and access the same from the 1st server. The following are the steps I ned to follow on the 1st server: Detached the database Moved the mdf & ldf files to 2nd machine/server Attach the database pointing to the 2nd server. The 1st and 2nd steps went fine, the problem is with the 3rd step. In the Attach Databases window, I clicked on ADD, it opened LOCATE DATABASE FILE, the folder structure of the 1st server. Is there any way I can change the SELECTED PATH and poin to the 2nd server I did even mapped network drive to the 2nd server but the mapped drive ...Show All

• Visual Studio 2008 (Pre-release) Why is XAML Serialization sandboxed?

  Why is XamlWriter.Save() sandboxed Am I understanding correctly that this is a limitation of the implementation and not security related It's very frustrating to have a nice way to capture the layout of a Canvas an store it, but find it doesn't work for XBAPs. Any other suggestions I don't want to write to the local disk. I want to serialize to a MemoryStream, then store the XML on a web server. The save method is used for this. Brian ...Show All

• Visual Studio Team System Could not load type 'Microsoft.Web.Services.BridgeModule'.

  I've included the ATLAS project files into my existing non-ATLAS project but since then I can't run the app as it comes up with the following Error: Could not load type 'Microsoft.Web.Services.BridgeModule'. Line 200: <httpModules> Line 201: <add name="ScriptModule" type="Microsoft.Web.Services.ScriptModule"/> Line 202: <add name="BridgeModule" type="Microsoft.Web.Services.BridgeModule"/> Line 203: <add name="WebResourceCompression" type="Microsoft.Web.Services.WebResourceCompressionModule"/> Line 204: </httpModules> I've followed another thread on this and tried solution such as copying Atlas dll into the ..Program Files\Mic ...Show All