Andreia M's Q&A profile

• SQL Server Control Flow Diverging then Converging Back

  I am somewhat new to SSIS and have a question on branching/control flow. We have 3 manufacturing facilities on AS400. Requirement were to create independent SSIS packages in case certain facilities were down, to not interrupt or fail other facilities. to be honest, I didn't want to maintain 3 * (each plant package) packages and decided to create one that takes in a command line parameter and will create seperate batch files (requirements for our archaic scheduling system) that pass in the plant to be processed. Everything works fine and the packages analyze the passed parameter with no problem and evaluate it when calling stored procedures int a SQL Task. I am required (I think - let me know if I'm wrong here) to have 3 seperate Data Fl ...Show All

• Visual Basic Register a vb.net in another system

    I developed a vb.net class library(ClassLibrary.dll) in .Net.  " How to use that ClasLibrary.Dll in another system". I.e., I use the dll in AXAPTA. In the class library, you should use the ComClass template for the classes that you want to use from AXAPTA. This will let your .NET classes be exposed as COM objects. Normally, a .NET class doesn't expose a COM interface, so it can't be used from a COM environment. Check out http://msdn.microsoft.com/vbrun/vbfusion , where I've written a bunch of articles about doing this sort of thing. ...Show All

• .NET Development NetWorking

  I want to write a code Using WINSOCK but in .Net I have not this control. what can i do plz guide me to write a Vb.Net Program to net working. ...Show All

• Visual C++ Multiple file extensions

  If I create a C++ project and select 'MFC application', there is a dialog where I can enter the file extension I want to use. If I want to use two different file extensions in my program, for example '.abc' and '.def', then what shall I do Peter Ritchie wrote: Simple Samples wrote: Also, I know that I have read MFC is definitely off-topic. I also was confused, but they were clear that MFC is off-topic. I have since then posted my comment many times that MFC is off-topic and this is the first time that anyone has questioned it. If I am wrong, then that is great as far as I am concerned. VC6 versions of MFC aren't supported here. MFC topics don't make sense i ...Show All

• Visual Studio Tools for Office VS2005 does not show MS Excel 9.0 in COM object list. What do I do?

  I wrote my program on my machine which is running VS 2005 and Office 2003. The program worked on my machine but the program is actually going to run on a machine with only Excel 2000 on it. So, when it runs on this other machine it does not open Excel and write data to it as it did on my machine. I assume this this due to having only the Excel 11.0 object library referenced in my project I tried to add the Excel 9.0 library but it does not appear in my list of COM objects so what do I do Will I need to change my connection string also from ... Dim sConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;" _ & "Data Source=" & XLFile _ & ";" & "Extended ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Skinned animation bone indices solution

  I found, through astounding coincidence, the function MeshHelper.FlattenSkeleton(). The documentation says that this is guaranteed to generate the same bone index numbers as the bone/weight generation for a mesh. I haven't tried it yet, but it seems as if this will be the solution to our animation woes -- with this function, you can write an animation processor without a custom importer. I'm posting this so that other poor souls searching the list will find the apparently recommended solution -- although an official comment from MSFT would be nice. (Even nicer would have been a pointer to this function in the first place, but I ain't complaining too loudly :-) Not for the boss. You may start save money to buy a whole cistern. There a ...Show All

• SQL Server how to set column name dynamically?

  HI chaps my scenario is that, i have a table in which i have column such as col01,col02,col03....col31 i want to retrieve the records related to that column by specifying the name dynamically (by using loop) as fist three character are same ( 'col ' ) and i have to do integer increment in last two character ( 01... 31). Is it possible that I can use variable for column name , if yes how or is there any other way to achieve this task waiting for your reply regards   fafnir wrote: Something like the following will work for you: create table DynCols (col01 int, col02 int, col11 int, col12 int) -- and so on, fo all 30 columns declare @query varchar(255) set @query = 'select ' declare @counter int ...Show All

• Software Development for Windows Vista cannot set Expanded property

  I have derived from ParallelActivityDesigner. My derivation manages custom branches derived from SequenceActivity. This mimics the same behaviour, that is available in an IfElseActivity. I have done this, because I cannot derive from IfElseActivity because it is sealed. 1. I don't understand, why most of the activity designers are sealed. It would be much easier for me, if I could for example derive from IfElseActivity. What's the reason for all the designers to be sealed 2. I cannot set the Expanded property within my derivative of SequentialActivityDesigner to false. It always returns true, because the property is implemented as follows in SequentialActivityDesigner: public override bool get_Expanded () ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Bad Lines Appear with Sprite.Draw with Redist. but not with SDK

  Hello Everyone, I am working on an isometric game pseudo 3D but using Direct3D. Primarily I am using one call to draw everything... (Sprite.Draw). Infact I even use only one sprite to draw all the images to the screen and have written all other collision detection and transforms myself using surface level operations... The only real hardware accelerated feature I am taking advantage of is color and alpha blending. Everything has been going fantastic and I am getting ready for a preview release in a few weeks but then I decided to test it on two more machines to make sure everything worked. Almost everything did... but some images are not being drawn to the screen correctly they will have shaded lines under or around them that were no ...Show All

• SQL Server Problem with SELECT, GROUP BY and aggregate function

  Hi all, I have a problem with an SQL-query and I don't know what the best solution would be to solve the problem. /*INSERT INTO WERKS ( WERKS.Z8601, WERKS.Z8602, WERKS.Z8603, WERKS.Z8604, WERKS.Z8605, WERKS.Z8606, WERKS.Z8607, WERKS.Z8608, WERKS.Z8609, WERKS.Z8610, WERKS.Z8611, WERKS.Z8621, WERKS.Z8622, WERKS.Z8623, WERKS.Z8624, WERKS.Z8625, WERKS.Z8626, WERKS.Z8627, WERKS.Z8628, WERKS.Z8629, WERKS.Z8630, WERKS.Z8631, WERKS.Z8632) */ SELECT 0, Stati.z4414, Stati.z4402, '', '', '', Isnull((select Srtas.z02 from Srtas where Srtas.z00 = Stati.z4400 and Srtas.z01 = Stati.z4414), ''), Isnull((select Klant.z0102 From Klant where Klant.z0101 = Stati.z4402), ''), '', '', '', sum (Case when Stati.z4407 = 200609 then Stati.z4409 Else 0 End) ...Show All

• Visual Studio Express Editions VB

  I have just installed VB express E on running VB and choosing 'Create Project' a 'New project' window appears...but, nothing happens please help me ...Show All

• SQL Server Error: The backup of the file or filegroup "sysft_XXXX_FT" is not permitted because it is not online

  Hi There, I am trying to do a full back up of a user database which has full text indexing on it. I use the maintenance plan wizard to set up a full backup. For some reason, I get this error. ================= Executing the query "BACKUP DATABASE [XXXX] TO [XXXX] WITH NOFORMAT, NOINIT, NAME = N'XXXX_backup_20060819040020', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "The backup of the file or filegroup "sysft_XXXX_FT" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data. BACKUP DATABASE is terminating abnormally.". Possible failure reasons: Problems with the query, " ...Show All

• SQL Server Connection manager or Data Source

  For seting up the connection should we use Connection Manager or New Connection From Data Source The advantage of using Data Source is that we have the connection avalilable at project level but I've studied it somewhere that Data Source is used for SSAS not SSIS. But I don't have enough explanation to give it to my team, that why I am not using Data Source. We are working on VSS, do we have to reset the connection managers if want to test our packages on some other machine(else than the one on which it was developed) Paarul wrote: For seting up the connection should we use Connection Manager or New Connection From Data Source The advantage of using Data Source is t ...Show All

• Windows Forms ComboBox Sync With DataGridView

  EmployeeDS ds = new EmployeeDS(); BindingSource bs = new BindingSource(); EmployeeDSTableAdapters.EmployeeTableAdapter da = new BindingOnRelation.EmployeeDSTableAdapters.EmployeeTableAdapter(); da.Fill(ds.Employee); EmployeeDSTableAdapters.CategoryTableAdapter daCat = new BindingOnRelation.EmployeeDSTableAdapters.CategoryTableAdapter(); daCat.Fill(ds.Category); bs.DataSource = ds; bs.DataMember = ds.Employee.ToString(); dataGridView1.DataSource = bs; BindingSource bsCat = new BindingSource(); bsCat.DataSource = bs; bsCat.DataMember = "FK_Employee_Category"; //ERROR in here comboBox1.DataSource = bsCat; comboBox1.DisplayMember = "Description"; comboBox1.ValueMember = " ...Show All

• Visual Studio 2008 (Pre-release) TextChange on LostFocus

  Is there a built-in way to determine whether the Text propertly of a TextBox change during LostFocus Or do I have to store the value and check it How about on a TextBlock Brian The textchanged event fires everytime the text is changed. if you need to determine if its during lostfocus then you can set a variable/flag and check it as you pointed out ...Show All