bolo's Q&A profile

• SQL Server JOB With SSIS Step Fails If Package Contains A Script Task

  I have a Job Step defined to execute a SSIS Package.  This SSIS package contains a Script Task.  The Job fails with the message "Package execution failed.  The step failed."  I am logging events in the package and when the packages gets  to the Script Task the log reports "The script files failed to load".  If I disable the Script Task from the package it executes fine.  Curiously, the package runs successfully with the Scritp task enabled using dtexecui and dtexec from the command line. Only if I include the Package in a job step with the Script Task enabled does it fail. Any help would be appr ...Show All

• SQL Server Maintanance Plan

  in the beginning i could create such plans without any problem, but since the workstations run's inside domain it doesn't work either with sa nor with system admin. any idea how i can solve that issue below you find the details of the exception i get. thanks in advance, =================================== Exception has been thrown by the target of an invocation. (mscorlib) ------------------------------ Program Location: at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) at System.RuntimeMe ...Show All

• Visual C++ Can't link a managed wrapper (mixed managed/native) assembly to a static lib???

  Unless I'm missing something, this seems like a fairly major limitation... I have a mixed manage and native "wrapper" assembly project that wraps a third party's static library. We do not have a DLL version of the third party library, just the .lib. In VS 2003 with managed extensions for C++, the project compiled and linked fine. Now, after having converted all the managed extension stuff to C++/CLI, I have it all compiling. However, it does not link because of multiply defined symbols (LNK2005 error). It appears the static library had linked (statically) to libcmt.lib When linking my project I get 20 or so linker errors like this ...Show All

• Visual C++ How Do I Make a Derived Class from the Set Class Container

  I'm trying to make a derived class from the associative container class Set. Please help. example class mySet : set { }; doesn't compile Learning wrote: I'm trying to make a derived class from the associative container class Set. Please help. example class mySet : set { }; doesn't compile Try : template <typename T> class myset : std::set<T> { }; ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Lighting problem with Dec2005 SDK?

  Hi; I can't get lighting to work with the dec2005 sdk. I created a simple cube mesh in maya, exported it, and loaded it into my project. But it shows up dim and faint - in fact the only light that seems to be showing is the ambient light. Here is my light code: Device.RenderState.Lighting = True Device.Lights(0).Type = LightType.Directional Device.Lights(0).Diffuse = Color.White Device.Lights(0).Direction = New Vector3(0, 0, 1) Device.Lights(0).Enabled = True Device.RenderState.Ambient = Color.FromArgb(&H202020) (Note that the lights().commit function no longer exists, even though a lot of examples men ...Show All

• Visual Studio Potential bug with MSBUILD / VS Output

  In the IDE (Aug CTP) I went into Tools | Options | Projects and Solutions | Build and Run and set the MSBuild verbosity to Normal.  After I was through I set it back to Minimal but the output window still displays the build sequence number before every line like so: 8> blah 8> blah 9> otherblah 9> otherblah I even exited VS and restarted and verified that the verbosity is set to Minimal but I still get these numbers prepended to every single line of build output.  It's kind of annoying. What's weird is that it didn't do that until I switched the MSBUILD verbosity from the defau ...Show All

• Windows Forms ParentControlDesigner - InvalidCastException

  Hi! In following code where the cast of the IComponentChangeService should be done a InvalidCastException gets thrown: public override void Initialize( IComponent component ) { base.Initialize( component ); IComponentChangeService changeService = this.GetService( typeof( IComponentChangeService )) as IComponentChangeService; if ( changeService != null ) { changeService.ComponentAdded += new ComponentEventHandler( this.OnComponentAdded ); } } This is a method of a designer class (inherited from ParentControlDesigner) for a custom toolbar. This toolbar is docked to the ...Show All

• Visual Studio Express Editions ER Diagrams

  Hello. Historically SQL server has shipped with a simple but extraordinarily effective database diagramming tool. For me its one of the compelling features that differentiates SQL from mySQL or postrgres. SQL Server Express Edition does not seem to include a diagramming tool. Is it possible to use one of the other express editions to create diagrams or is there another way to do this Thanks for taking the time to respond. renen. If you're talking about the SQL Server 2000 Diagrams feature, you can create a diagram using any of the Express products. To do this, create a Windows Forms or ASP.NET Project, in the Solution Explorer, c ...Show All

• Windows Forms MSDataSetGenerator and xsd:import

  Hi, I'm trying to use the MSDataSetGenerator with a couple of XSD files that rely on importing some common xsd files with <xsd:import>. However, when setting the schemaLocation attribute to a relative path I always get an error message saying something like: Type [insert type name here] is not declared, or is not a simple type. It works fine if I use an absolute path, but that certainly isn't a good option.. Any clues to a solution /Anders A simple example: MyIncludedSchema.xsd < xml version="1.0" encoding="utf-8" > <xs:schema id="MyIncludedSchema" t ...Show All

• Visual C# Create Too Many Forms

  is there way to create form just when i want like vb6 form.show() shows the form but in C# when i want to show the for i have to use form frm = new form(); that create too many form so when i pass value i cant pass it to the certain form i want and other question if i have more than one form how i can pass the value to the form i want i hope that it was clear sorry for my bad english You shouldn't be creating more than one instance of the same form, unless you want to show it more than once at the same time. If you have a form you show over and over again, mak ...Show All

• SQL Server Time Analysis Dimension (Shell Dimension) Calculations not working in AS2005

  Hello, In AS 2000, we had created a "shell dimension" to calculate different time periods (YTD, MTD, previous MTD, Trailing 28 days). This dimension basically had several calculated members which did these time calculations. We would reference these members by [Period Calculations].[YTD] for example. In AS 2005, is there an equvilent way to do this without breaking existing cubes and reports (which have mdx referencing this shell dimension) ...Show All

• Software Development for Windows Vista What are the important changes in WWF Beta 2 relative to WWF Beta 1?

  What are the important changes in WWF Beta 2 relative to WWF Beta 1 Michael - you can get it from Paul's blog post - here http://blogs.msdn.com/pandrew/archive/2006/01/19/UpgradeWFBeta2.aspx ...Show All

• .NET Development FtpWebRequest re-sending USER and PASS commands half way through download loop

  Well, the title says it all really: I'm using FtpWebRequest to download multiple files as follows: private string GetFile(Uri uri) { string un = Misc.ReadRegKey("ParserFtpUsername"); string pwd = Misc.ReadRegKey("ParserFtpPwd"); string file; NetworkCredential cred = new NetworkCredential(un, pwd); WebProxy pxy = new WebProxy(); pxy.UseDefaultCredentials = true; FtpWebRequest wr = (FtpWebRequest)WebRequest.Create(uri); wr.Credentials = cred; wr.Proxy = pxy; wr.UseBinary = false; wr.Method = WebRequestMethods.Ftp.DownloadFile; FtpWebResponse resp = (FtpWebResponse)wr.GetResponse(); ...Show All

• Visual C++ another hook question

  Hi.. i wanna send a meesage to a application when me callback function of the hook is called.. but i also wanna pass it some parameters besides the original wParam and lParam.. typedef struct INFO { LPARAM lParam; // The original lParam UINT code; // the code (paramters of callback fnc HHOOK hhook; // handle to the hook } so it would be like.. static LRESULT CALLBACK msghook(UINT nCode, WPARAM wParam, LPARAM lParam) { if(nCode < 0) { CallNextHookEx(hook, nCode, wParam, lParam); return 0; } INFO f; f.code=nCode; f.hhook=hook; f.lParam=lParam; SendMessage(mForm,messageCode, wParam, f ); return Ca ...Show All

• Visual C# SQL Server 2005 at Visual C# 2005 Express Edition Beta

  Does installing the C# Beta together with the included SQL Server 2005 will not affect my existing MSSQL server 2000 installed .  And why I can't connect to the data source when I try to connect from c# to my SQL2000 database Any help is very much appreciated This morning I install the MS SQL server 2005 to try again adding new data source but i can't still connect, this is the error message "FAILED TO GENERATE A USER INSTANCE OF SQL SERVER DUE TO A FAILURE IN STARTING THE PROCESS FOR THE USER INSTANCE. THE CONNECTION WILL BE CLOSED." then again i try it generates another error "UNABLE TO OPEN PHYSICAL FILE C:\PROGRA~1\SQL\myfile ...Show All