Andreas Öhlund's Q&A profile

• SQL Server Breakpoint doesn't work

  I've got a breakpoint in a script task. The script task executes successfully but doesn't break. Short and sweet this one. Anyone any idea why it might not -Jamie SSIS does not currently support breakpoints in script components. You will need to put some logging information in your script component see my post http://www.sqljunkies.com/WebLog/simons/archive/2005/08/03/SSIS_Script_Component_Debugging.aspx ...Show All

• SQL Server Grant All function giving errors

  I'm migrating from 2000 to 2005, what is the best way to handle the following error: The ALL permission is deprecated and maintained only for compatibility. It DOES NOT imply ALL permissions defined on the entity The code is below: DECLARE @sp_name AS sysname; DECLARE syscursor CURSOR FOR   SELECT name FROM sysobjects   WHERE (xtype = 'P' or xtype='V') AND ((status & 0x80000000) = 0); OPEN syscursor; FETCH NEXT FROM syscursor INTO @sp_name; WHILE (@@FETCH_STATUS = 0) BEGIN   EXECUTE ('GRANT all ON ' + @sp_name + ' TO Public');   FETCH NEXT FROM syscursor INTO @sp_name; END CLOSE syscursor; DEA ...Show All

• SQL Server concatenate a string within a loop from a temp table

  I need help. I have a large table that looks like this. (ID INT NOT NULL IDENTITY(1,1),PK INT , pocket VARCHAR(10)) 1, 1, p1 2, 1, p2 3, 2, p3 4, 2, p4 5, 3, p5 6, 3, p6 7, 4, p7 8, 5, p1 9, 5, p2 10,5, p83 i would like to loop through the table and concatenate the pocket filed for all the records that has the same pk. and insert the pk and the concatenated string into another table in a timely manner. can anyone help Emad An easy way (but slow if you have a big table) to do this is to use a cursor. Bellow is a fully functional example. Hope it helps! DECLARE @MyTable TABLE ...Show All

• Windows Forms UserControl GotFocus and LostFocus events

  I'm working on making a UserControl with a label and a vScrollBar because the numericUpDown control has no way to hide the scroll buttons when the control loses focus. Problem I'm having is with the focusing of the control once its in the form. As it is now I have to to wire up an event when the user clicks in the label in the control to let the form know it has focus, then in the form, for the eventhandler, I have to manually set the focus to the control. Seems once I lose focus to another control I can't regain the focus by clicking on it. Is this a bug or what I would think that the basic events (especially focusing) would already be hand ...Show All

• Visual Basic How to get the user/owner name of a process in vb.net???

  Could anybody tell me How to get the user/owner name of a process in vb.net The reason I need it is because I developed an application, which I will put on the winnt enviroment, I want to allow multiple instance. but only allow one single instance per user. I am using Application.Run(MyMainForm) to start my application Thanks, Joseph I'm glad you had a positive experience with NGEN . I just wanted to confirm that you do indeed get a single instance per login (my >90% hunch was correct) Best regards, Johan Stenberg ...Show All

• SQL Server Package configuration help !

  hi, I have a package that executes nicely. When I enable "Package Configuration", create an XML config file and only select the Connection Managers (2 file connection managers and 1 data source), I get the following error (when executing the package in debug mode from designer): Information: 0x40016041 at MyPackage: The package is attempting to configure from the XML file "C:\src\myconfig.dtsConfig". SSIS package "MyPackage.dtsx" starting. Information: 0x4004300A at Data Flow Task -  Extract my_file_src, DTS.Pipeline: Validation phase is beginning Error: 0xC0202009 at MyPackage, Connection manager "MyConnMgr": An OLE DB error has occur ...Show All

• Software Development for Windows Vista Workflow Persistence & Event Arguments

  I'm developing a State Machine workflow that passes parameters through events. The Workflow will have to persist its state in a SQL database. My understanding is that the persistence services will persist the current state of the Workflow (e.g. which state the Workflow is in). The workflow is rather useless without also persisting the parameters passed in the event arguments. Will the Workflow Persistence Services automatically persist the values passed in the event arguments or will I have to manually persist these parameters in the database Thank you in advance, -- Sean The parameters that you passed in ...Show All

• Visual Studio 2008 (Pre-release) Why will Dlinq fail ?

  Microsoft tries to helping object developers to close the gap between the relational world and the object world.And they call this " object modelling approach " Dlinq. Using " custom business entities " in enterprise programming with Dlinq might seem the best thing after " sliced bread " but it isn't. For my part I have written my Mappers and used commercial OR/M tools. They mostly provide the same thing. __Read the table from the database. ___Put that into a some HELPER thing.( DAO,DAL,ORM) ____Put that into your custom business object _____Read from your business object.(if u can :) ) I see NO REASON for this " Unnecessary Pull ...Show All

• Visual Studio difference between cr 8.5 and cr 11

  Hello all I want to know what is difference between crystal report 8.5 (which is along with VS 2003) and Crystal Report 11 thanks Nilay Just to add to Paul's post, all of this can be found at the following web site: http://www.businessobjects.com/products/reporting/crystalreports/net/vsnet.asp Keith - Business Objects ...Show All

• Visual Studio Team System Team foundation toolbar missing in excel

  I've installed vsts and the client etc, and also the "MS Visual Studio Tools for Office System 2005 Runtime Beta 2", yet I have no toolbar for working with Team Foundation server. I have Office 2003 installed, do I have to install office 2005 or is there something I'm missing Thanks Marvellous, that worked a treat. Found the following articles searching for xllex in case anyone else visits here: http://www.dotnet247.com/247reference/msgs/57/286768.aspx http://support.microsoft.com/default.aspx scid=kb;EN-US;320369 Cheers ...Show All

• Visual Studio 2008 (Pre-release) Can someone give me an example of how to set an image?

  hi, I'm trying to set an image in my code, but it doesn't seem to work. Can someone give me a simple .xaml and .cs of how to set an image. Mine look like this... .xaml: <Window xmlns="http://schemas.microsoft.com/winfx/avalon/2005" xmlns:x="http://schemas.microsoft.com/winfx/xaml/2005" Title="TrackingApplication" Width="953" Height="753"> <TabPanel> <TabControl Width="400" Height="500"> <TabItem Width="90" Height="20" Header="MapView"> <Grid HorizontalAlignment="Center" VerticalAlignment= ...Show All

• Visual Basic How Can I Access Other Open Application Windows?

  I am trying to write a program that interacts with another third party application window. They do not expose an API that I can use, so I have to hack my way through it. The sad thing is I have actually done this in the past (I had to process a large number of cases, so I wrote a routine that pulled case numbers from an open excel window, and then closed them out in this third party application). I just can't remember how I accessed and discovered the other open application windows! What I am really trying to accomplish is to be able to verify the appropriate application window is open, dock my application to the side of it, and read ...Show All

• SQL Server Execute Integration Package from a C# Solution

  Hi all Does somebody know how I can execute a SSIS Package on a SQL 2005 Server I need to execute from a C# Solution which is running on a client. Thanks for any comments Best regards Frank Uray Doug, I ran into the exact same issue you did. I needed to invoke a package from an asp.net app and wanted to do it via a CLR stored proc. Oh well... I documented all my SSIS experiences in a series of articles: http://www.blognet.info/weblogs/entry.php u=adhalejr&e_id=849 Maybe that will provide some pointers. Donnie ...Show All

• SQL Server XML query output to File in SQL Server 2000?

  Hey All,   I wanted to build a simple scheduled task that hits my document library table in SQL Server, builds an RSS (XML) file based on that table, and then saves the resulting XML as a flat .rss file.  I'm using SQL Server 2000, and so far I've gotten SQL Server to output the XML from the table in the right format for RSS (using FOR XML EXPLICIT) as a query.  I'm not sure where to go from here - can't figure out how to go from the query output to a flat file.  My idea was to have the whole thing bundled into a stored procedure that I can call for an INSERT trigger on my document library table.  Also, I notic ...Show All

• SQL Server SSIS setup for team work

  I would like to setup SSIS project so that multiple developers can work on same project. I am having issues with protectionlevel properties while another developer opens the package created by other developer. Can anyone guide me on setting up project so that multiple developers could open the package and run (not simaltaneously though). Also tips on setting up source safe or team foundation will be appreciated! Thanks Mahesh User-level protection level only work if a single developer work on a package, so you need to either 1) switch to password-based protection level, or 2) switch to do-not-save-sensitive protection level an ...Show All