AdriaanDavel's Q&A profile
SQL Server Accesing package Variable in Conditional Component
Hello Experts, I am trying to load data to a sql table from flat file..I have a script component which will validate the data. I am also firing the errros when data validation fails. Once I encounter an error I want the whole package to be aborted. What I have done is declared a variable called errorcount (Scope :Package) and I am incrmenting this variable everytime an error is raised and next I have a Conditional Split which will check if this variable count is greater than 0 if yes I will not update the table.This is the only way I think this will work. error I am getting is :The collection of variables locked for read and write access is not available outside of PostExecute. I understand they r in the same data flow thats the r ...Show All
SQL Server SSIS AcquireConnection Error
I have written an SSIS Package that connects to an Oracle database through SQL Authentication. Whenever I execute the package in BIDS it executes without a problem but when I try to schedule the package as a Job I recieve an AcquireConnection Error. Any help I have tried the solutions outlined in http://support.microsoft.com/kb/918760 and have read through the KB but have found few solutions that pertain to connecting to remote Oracle databases through SQL Authentication. Any help would be much appreicated. KirkHaselden wrote: So, you're using SQL Server authentication to try to access your Oracle server Yes Sir, In the connection manager I am using the 'Na tive OLE DB\Mircosoft OL ...Show All
SQL Server Windows and Forms Authentication issues
I have a user who is trying to access the SQL 2005 server with 2 seperate accounts(using Windows Authentication). With one account he can connect just fine, but with the seccond he recieves a logon fail error. The only difference that we can tell is that the first account uses a password for our kerberos domain, and the second (that fails) uses a longer pass phrase (which does use spaces as characters). My intuition tells me that shouldn't matter, but I've been wrong before. Can anyone confirm this, or correct me if I'm wrong This is using ASP.NET 2005 for the front end. The exact Exception details are: "System.Data.SqlClient.SqlException: Login failed for user 'domain\user " The stack tra ...Show All
Visual Basic Good Systems and Analysis Design
Wher can I get some free help on Systems analysis and design for VB.net applications. I'd check out comtent on msdn, with components such as the enterprise library they build on established patterns and provide some clues as to an implementation. Microsoft certification also addresses the subject of architecting applications - look at the examination study materials for MCSD certification. These are based around either VB.Net or C# and have a design/architectural component. The web is full of information of design methodologies - AGILE, SCRUM, WATERFALL are certain design methodologies that come to mind that can be applied. Try you local .NET users group - there are often experienced developers/architects there that can also ...Show All
SQL Server How do I Install SQL Server Compact Edition from a storage card on a device
Hi all experts, in case of a cold boot on a device, I insert the the flash SD disk in a device and install the NETCF 2.0 by clicking on the NETCFv2.wm.armv4i.cab which iI previously copied, that's fine it works OK, but is there a cab file for Sql server CE that i can install from the flash disk as well, I'm trying the Sqlce30setupen.msi, SQLServerCE31-EN.msi, an I get a device message "There is no application associated....." TIA Jack You need the cab files located at: C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Mobile\v3.0\wce500\armv4i For Mobile 5, Pocket PC, base: sqlce30.ppc.wce5.armv4i.CAB (required) For Mobile 5, Pocket PC, Replica ...Show All
Visual Studio Suggestion: Report Export
If a user clicks the export button, the file extension appears in the file name. For example, MonthlyReport.Pdf It has happened that the user then adds their own text, in this case - the month name. So we get MonthlyReport.pdf April 07 Unfortunately, this means the document is now of type '07'. If a user does the same thing in Word, it would save as MonthlyReport.Doc April 07.Doc. Can I suggest that the .pdf is removed from the file name box, or else have the ReportViewer always adds .pdf to the end. Btw, anyone know of a way round this for now I hate having to talk users through changing file extensions! Thanks Brian. As it happens, I had to write my own export as management decided ...Show All
.NET Development How Load a XML file with a XSD file into a DataSet
Ok im in trouble! this night i drink some weird stuff with some friend's and i cant think straight and simple i dont understand... "plus" i never work with XSD files so... i sucks today! Any help would be great!! Thanks. At this stage I'm not sure but I would have thought that the xml file you have (not the schema) would contain all the tables if this was the case then I'm sure that the dataset would have loaded them all, indexed (0, 1, 2......) How many tables does the Xml file contain ...Show All
Visual Studio Opening a PDF in the IDE
Hi, Is there a way to open a PDF in the IDE I would like to be able to open PDF's in the same area that the Start page opens in. Thanks, for your consideration. - Phil Craig, Thanks, for the prompt and informative reply. I was afraid it would be something like this. Much appreciated. Philip ...Show All
Visual Studio Team System Illegal Characters in Path
Hi i am facing issue in copying files from one destination to another. TFSBuild.proj looks like this < Target Name = " AfterCompile " > < Exec Command = " " c:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv " " c:\projects\cp\CP1.1 SP1\BVT_100506\Sources\Release 1.1 Sp1\Source\Assemblies\MS.CP.ServerSolution\MS.CP.1.0.ServerSolution\MS.CP.1.0.ServerSolution.sln " /Build " Debug|Mixed Platforms " /Project MS.CP.WebService\MS.CP.WebService.vdproj " /> < Copy SourceFiles = " " c:\projects\cp\Debug\MSCPWebService.msi " " DestinationFolder = " " $(OutDir) " " ...Show All
Software Development for Windows Vista about exception "Queue '......' ' is not enabled."
Following here is my code : ////////// Initialize the StateMachine, MySrv implements the IBugService interface. ................. //////// Raise some events MySrv.RaiseBugCreatedEvent(instance.InstanceId, 1); MySrv.RaiseBugResolvedEvent(instance.InstanceId, 1); ........... the statemachine has been designed that a bug can be resolved when it is just created. When my program runs at the second line "MySrv.RaiseBugResolvedEvent(instance.InstanceId, 1);", the system sometimes throws the exception "ex.InnerException {"Queue 'Message Properties Interface Type:StateMachineApp.IBugService Method Name:BugResolved CorrelationValues: ' is not enabled."} System.Exception { ...Show All
Visual C# C# Naming Conventions - ID
http://msdn2.microsoft.com/en-us/library/ms182256.aspx This page details that "ID" (meaning "identification") is not an acronym, but an abbreviation and so should be special-cased to cause a violation of the "Short acronyms should be uppercase" rule. I have interpreted this "special-cased" "violation" to be legal and to use Pascal casing, and so in every instance ID should be presented as "Id". For example: ClientId IdForClient Id And should not be presented: ClientID IDForClient ID Is this the correct interpretation Nick Hi Nick, Your interpretation is incorrect. What MS means is that the ID is "not an acronym but a short form of identifier", even then it should be pres ...Show All
SQL Server Unable to Open DTS Packages Anymore
Hi, I installed the dts designer component for 2005 so I could migrate over some 2000 packages and was able to successfully open and run dts packages under 2005. Then all of a sudden I get this error msg and can't open them, migrate them, export them, etc: "here were errors loading the package "MyPackageName": [DNETLIB][ConnectionOpen (Invalid Instance()).] Invalid connection. (Microsoft.SqlServer.DtsObjectExporerUI)" That is not a typo, it actually says "here were errors..." instead of "There were errors..." I've tried the obvious, repair the dts designer component and rebooting, no luck. Anybody seen this Hope this is the right group to post to... Thx ...Show All
Visual C# How can I retrieve advanced file information?
...Like the Title of a song, the Bitrate, Album, etc. Thanks, if you used the WMP SDK then things would be alot easier as it gets all the information for you of a specific media file. http://msdn.microsoft.com/library/default.asp url=/library/en-us/dncodefun/html/code4fun01242003.asp I dont think you can get the bitrate of the mp3 file as easily as you do with the ID3 tags I have posted. ...Show All
Game Technologies: DirectX, XNA, XACT, etc. BoundingBox.Contains doesn't work after a transform?
Hi All, I have some test code that uses BoundingBox.Contains to see if a vector lies inside the bounding box. It works fine until I transform the point vector and bounding box min/max vectors by a matrix. The coordinates look right, but the function retuns disjoint. I know I must be missing something here, but I can't figure it out. The values after translation are: BoundingBox.Min: 0, 0, 0 BoundingBox.Max: 1, 0.99999999, -1 Point: 0.5, 0.5, -0.5 My test code just replaces the standard game Update() method. You also need to set the game Draw() methods graphics device clear call to graphics.GraphicsDevice.Clear(color); Here's the Update method and color declaration: Color color = new Color ( Color .Yellow.To ...Show All
.NET Development SerialPort component makes app blow up
Hi, We have some serious problem with the serialport component in .net 2. We are trying to interact with an industry scale. and it works _sometimes_ but 70% of the time , the app just blows upp , "the application has encountered a problem and needs to close" and we get the same problem on each of the machines. and it occurs directly when we try to do "port.Open()" and after that the comport is locked (or in use by the crashed process) Any ideas what can cause this First I thought it might be some gui threading issues but since it occurs directly on open I dont know what to think anymore. we have tried this on each of the machines at the place where the scales are and also tried connecting a scale to our ...Show All