colossus2006's Q&A profile

• SQL Server "command line parameters are invalid " is the output for a SQL job to run SSIS package

  Hello, I created a SSIS package that has a flat file manager whose connection string is a package variable, the reason is that there is a foreachfile container loop to loop thru CSV format files in a directory and load them to a sql table. The package execution is working in the designer studio as well as in the management studio-- a copy was saved to a sql 2005 server where a sql job is deployed to run the package. However when I ran the job, it claims successful but doesn’t do anything in reality. If I checked the box failing the package upon validation warming, the job will fail with the error: the command line paramet ...Show All

• .NET Development SQL to retrievedata

  Hey Guys: I have seen this done in a program and at one time i did it but not exactly get it right. I have two tables in my data base. The first is a table with the PubID and a number that corresponds with the second table with a list of titles. table1---is PubID----and number of title is 10----so when i enter the number 10 in the column i want the title to appear in column 3. PubID TitleNum Title 1411 10 Jack and Jill sucks I want to save and delete in table1 one but not in table 2. Now i ask you Can you help me with this one I know it can be done I saw it but not the code. ...Show All

• Windows Forms book for learning to develop controls

  I can't seem to find a good book focusing on developing custom controls.  Every book I've bought or looked through seems to just skim the surface of creating controls because the book as a whole focuses on either asp.net or win forms or something larger in scale and therefore only devotes maybe 1 chapter to custom controls.  I've looked through&nb ...Show All

• Visual Basic need to seperate field into first, last, middle initial

  I have a field with last name, first name, middle initial, second first name, second MI, Title. I need to seperate these out to seperate columns. I have done it in 25 queries in access. Is there an easier way If you have them in VB, then you can seperate them using regular expressions.  If you want to do it within the database, you should ask in the SQL forums.  <edit> Let me clarify: if you want to pull the data into VB and then store it again, you can use regular expressions.  If you want to write a stored proc, so the data gets manipulated entirely by SQL, then you need to ask in ...Show All

• Visual C++ can visual studio 6.0 msdn and .net 2005 mdsn can be intalled together?

  would each software know to run the right msdn thanks, mmmm. my .net 2005 msdn is allready installed , should I delete it so that I can install VS6 first or it doesn't matter thanks, ...Show All

• Windows Forms is there any way to prevent an MDI form to leave focus

  i would like to prompt when an MDI form is about to lose focus, (for example click on another MDI form), and if de user decides to cancel it, leave the focus with de ActiveMDIChild, otherwise, proceed and change de active MDI. i am using VS with C#. Thanks ...Show All

• SQL Server Restricting data in Report Builder

  Hi guys, I have a question on restricting a data using some kind of dynamic parameter when users are using Microsoft Reporting Services Report Builder. I saw that I can set permissions and restrictions for report model items like columns, but I want the users be able to see all the columns, but the actual data that gets pulled needs to be restricted using a database table (bridge table) that assigns the users to what they are able to see. Is there anyway that the report builder can restrict the data itself using windows authentication or login so that the users can able to see their data and not others while all users having access to ...Show All

• Windows Forms how to open form2 from a child thread?

  Hi !   I am trying to open a form2 from child thread i can do this for the UI/ Worker thread but cannot from the child thread      Code: Dim t As New Thread(AddressOf openfrm)              t.IsBackground = True              t.Start()  sub openfrm()  Dim frm2 as new form2  frm2.visible =  ...Show All

• Visual C++ aspell compilation problems

  Hi, I tried to post on the forum but it kept coming up with an internal error so i was wondering if you could help me with the following:I have recently been trying to compile aspell (a spell checker written in c and c++) in visual studio .NET (2003) which has taken forever but i managed to get it to compile a dll now. When i come to add this dll file into another project which will be using the methods from this dll it keeps giving the following error and not allowing me to add it: "Add Reference: Error adding reference to the project.". Does anyone have any suggestions on how to overcome this Any information woul ...Show All

• SQL Server RS Web Service

  Hi, I am getting the following error when tries to call any web method of ReportExecution2005 Web Service from a 2003 Web application. "Server did not recognize the value of HTTP Header SOAPAction: http://schemas.microsoft.com/sqlserver/2005/01/12/reporting/reportingservices/LoadReport ." Please someone suggest me how to fix this issue. Thanks Anobe Hi, It was working with VS 2005. It was giving problem with VS 2003 only, is there any additional settings to be done And this is happening only to ReportExecution2005 Webservice, it not happeing to Reportservice webservice, which is also hosted on the same 2005 r ...Show All

• Visual Studio 2008 (Pre-release) Load image into richtext box

  Hi anybody know how to load image or any shapes like circle , rectangle and etc.. into a richtext box at runtime. thanx Sniwas TextRange tr = new TextRange (RTB.CaretPosition, RTB.CaretPosition); tr.Load( Stream , DataFormats .Bitmap); ...Show All

• SQL Server Looping through rows in flat file

  I'd appreciate some guidance on how to solve a problem. I have a flat file of the format Header1 Header2 Header3 Data Record Data Record ... etc. ... Data Record Trailer1 Trailer2 I want to loop through each data record. I want to take a column value (string) from each row, and call a stored procedure passing in that value. The s/p will return another string which I want to use to update the original column value from the flat file. If I can't update the original column value I'm happy to add a derived column. Once I've done this "lookup" for all records, I want to re-create the flat file again with the new column values. I don't need a deta ...Show All

• Windows Live Developer Forums How to create a geo-fence

  The PolyLine feature is a great feature in V3. I can now create a polygon for my geo-fence. However, I don't know how to figure out whether a new LatLong is within my previously defined polygon. Can somebody help Thanks. I haven't had the need to do it myself yet, but the only ways I could think to do it would be by some sort of mathematical calculation, or make use of some other sort of software which does. MAYBE you can see if VML, which is what VE uses to draw the polylines can be utilized, but I don't know how if that even is possible. ...Show All

• Visual Studio Team System File/Folder-level security

  Hi all, I'm not sure whether this question should goes into VSS2005 or TS, but we have high requirements on security. Let's assume we created Team Project, and 5 developers are working on it. However, only 2 senior developers are authorized to access some core source codes, and the rest should be able to do their own parts without the ability to read or open the core source codes. Can this scenario be achieved in VSTS A brief look of the scenario: SolutionA: \Core <= Only senior developers can access \DevA <= Only DevA and senior devs can access \DevB <= Only DevB and senior devs can access \DevC <= Only DevC and senior devs can ...Show All

• Visual Studio Loading an Embedded Resource

  I have added an RDLC to my project.  I need to be able to load this into a stream so I can use LocalReport.LoadReportDefinition.  Does anybody have any sample code of how to load the embedded resource into a stream object NOTE: I know about the ReportEmbeddedResource property.  I can't use this because the viewer is in a different assembly than the embedded resource. It doesn't appear you can use ResourceManager to get at this. This works though: Dim reportStream As IO.Stream = Me.GetType.Assembly.GetManifestResourceStream("ReportTest.Test.rdlc") ReportViewer1.LocalReport.Load ...Show All