Bobo1234's Q&A profile

• SQL Server Editing SSIS Packages

  I have successfully created several SSIS packages in the Development Studio. I want to schedule those packages to run with SQL Agent. The only way I could schedule them was to go to File>Save copy as...(not save as) which would give me a choice of either to save it to SQL Server or SSIS Package Store. Using this method allowed me to schedule the package but then I couldn't figure out how to edit the package without going back into the Development Studio, right-clicking on SSIS packages and selecting "Add Existing Package" and selecting that package from the SSIS Package store then opening it to edit. That seems like a lot of work to edit a package. Is that the desired way to create, save, schedule and edit a SSIS package ...Show All

• SQL Server SSAS Cellset help urgently needed, please

  Hello, I am trying to write an SSIS package which will extract data from a cube, which cab then be inserted into a table in a SQL database I started by creating an ExecueSLQL ask, but the results I got back seemed to include other stuff, not the same results I would see if I ran the MDX in a query window. So I was unable to map the results to my SSIS variables for the next container to use in the package. EG this query: WITH MEMBER [Measures].[AttributeID] AS '1' SELECT {[Measures].[ Balance], [Measures].[AttributeID]} ON COLUMNS, {[Date].[Calendar].[Month].&[2006-Feb]} ON ROWS FROM [Accounts Brings back (in Management Studio): Balance AttributeID 2006-Feb 83,812,057,273.89 1 But ...Show All

• Smart Device Development Big dialog on small PPC screen

  I make dialog, what not fin on the screen. I try to use flag SHIDIF_WANTSCROLLBAR in function SHInitDialog( ), but vertical scrollbar not displaying or if I set dialog window style WS_VSCROLL scrollbar is displaying, but does not influence upon dialog scrolling. What I do wrong ...Show All

• Software Development for Windows Vista restoring all workflows from persisted storage

  Within the WF runtime, i see runtime.GetWorkflow(Guid) and instance.Load(). However, the typical use of my app would be that the user turns it off occasionally (this would prompt me to call Unload() on all the workflows), and turns it back on (this would necessitate restoring all the persisted workflows) How do i ask the runtime to restore all the persisted workflows I don't see a: runtime.GetAllWorkflows() Is there a way to do this Thanks. I understand what you're saying, but it does seem odd that connecting the runtime to a persistence service wouldn't do this automatically and consistently, across any peristence service you use, or better, to have a method like: GetAllWorkflowsFromStorag ...Show All

• SQL Server Need a sysadmin login

  We’re running mixed mode authentication on our SQL Servers. To make the server “safer” builtin\admininstrators no longer have sysadmin role on the sql server. If there is only one login with sysadmin role, and we lose track of the password, is there any way to recover it How could we reset the password or create a new sa account with a new password This situation has not occurred, but I’m worried about how to recover from it should it occur. This question relates to SQL 2000 and SQL 2005. David Zokaites, DBA & Software Engineer Jens, Thanks for the information. I thought the scenario might lock me out of sysadmin on the sql server. I will certainly make sure we have a secondary ...Show All

• Visual C++ Shallow Copy , Deep Copy , Memberwise Copy ,Bitwise copy

  hello ppl, i searched thru google but i didnt find the exact explanation for constructors. Shallow Copy , Deep Copy , Memberwise Copy ,Bitwise copy i got some conflicting answers.. and what is the difference between them.. .pls help me.. manish Yes, "byte by byte" is more appropriate. That "bit by bit" thing was just a form of speech like "bitwise copy". Regards Sahir ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 3DS Max export

  Hello everyone, I have been trying to export models from 3DS max for use in my XNA program. The trouble I keep running into is that the axis keep getting rotated and/or flipped from what's in Max. In order to test this, I have created a model that acts as an axis gizmo, with a cone pointing down the X axis, a Rectangle down the Y and a cylinder down the Z. I have exported the model three different ways: Max's built in .fbx exporter - The X points correctly, but Max's Z is now XNA's Y, and Max's Y is now XNA's -Z (Left-Handed). PandaSoft DirectX Exporter (with Left-Handed coordinates turned ON) - The same as the FBX exporter PandaSoft DirectX Exporter ( with Left-Handed coordinates turned OFF) - The X points correctly, the Y points correct ...Show All

• Visual Studio Team System Create new project - Failed with TF30162

  Hi, I try to create a new TFS project , using Team System Explorer, and it fails with : " Event Description: TF30162: Task "SharePointPortal" from Group "Portal" failed Exception Type: Microsoft.TeamFoundation.Client.PcwException Exception Message: Insufficient permissions on the Windows SharePoint Services at k2 to create a new site." The user it is member in the SQL Server Reporting Services as System Administrator, is also member in the Windows SharePoint Services administration group, and i also grant rights using : "tfssecurity /server:http://k2:8080 /a+ $namespace create_projects n:"mydomain\myuser" ALLOW" what else must be done that the user can create an new project we use Team Fou ...Show All

• Visual Studio Tools for Office User Settings

  Hello, Can someone pls tell me where the user settings are stored by a VSTO Outlook add-in I see something like the path below in my application data folder but I wonder, with the Microsoft_Corporation folder, whether this is for development only or the same for deployment also. I read in a blog from last year (see last Q&A) that VSTO did not support user.config so I'm confused. Thanks, Tad C:\Documents and Settings\{user name}\Local Settings\Application Data\Microsoft_Corporation\Outlook_Solution.dll.manif_Url_siekusdtr4oeycmzmgjrhu3lcr3gnycg\11.0.8010\user.config UserSettings I presume you are working on the premise of a Windows Forms Application and a config file that is associated to ...Show All

• Visual Studio Team System Multiple TFS Projects

  I am planning out our TFS strategy. I have read MS recommendations that say not to create a lot of Team Projects, but this concept mankes many of the reports useless: If I have 10 web services in a single TFS Project, and each has its own solution file. If I build one of them, the build report contains all the check-ins since the last build, even though many of them had nothing to do with the single web service I am building. My work item reports give me all work items for all the web services, not just the one I am working on. ... Wy the "minimize Team Projects" recommendation Regarding the check-ins, make sure you customize the build workspace XML file to narrow the path and on ...Show All

• SQL Server sql agent

  Hi all, I am using SQL Server Express with Advanced features. I used to use the SQL agent in SQL Server 2000 to run a stored procedure that populated a table in my database each night. I cant seem to do this with SQL Server Express. Is there another way to run this stored procedure each night and populate the table with the data returned. I read about using Scheduled Tasks in Windows but Im not really familar with this. Would really appreciate any ideas. Thanks, Cathie Hi, I downloaded and registered Express Agent from Vale Software...excellent prog. did everything I wanted. About 70 dollars. But if you want to do things the hard way, write your sql query and save to file <filename>.sql t ...Show All

• SQL Server Day of the month

  I am trying to code a proceedure that will run every weekend. This process will run for a number of hours beginning at 0900 Saturday and ending at 2100 Sunday. However, on the 3rd weekend of the month, I need it run for a shorter time and to also skip some tables. What I have now to find the day of the month I need is Begin SET @3rdSaturday = @1stDayMonth /*Loops until the date of the first Saturday(DayofWeek #7) of the current month is found */ WHILE DATEPART(dw,@3rdSaturday) <> 7 /*Adds 1 day to the first day of the month until it reaches the date of the first Friday of the month */ SET @3rdSaturday = DATEADD(d,1,@3rdSaturday) /*Adds 14 days to the first Friday of the month. The end result is the 3rd Fridays date ...Show All

• .NET Development How to know what exceptions a method can throw?

  I was reading in some other posts that you only have to catch known exceptions. And that it is not allowed to catch Exception like this: private void CheckCancelEntryWeighingRecords() { try { mis.Transfer(data.CsvData); //Call to a third party dll } catch (Exception ex) { LogError("Error occured in CheckCancelEntryWeighingRecords", ex); } } How can I know what exceptions a method can throw So that i can decide on which situation i can recover and on which not I know that the Framework.NET has documented the most exceptions. But what about third party dll's with bad of no documentation I also know i could use reflector to look what the possible exceptions a ...Show All

• SQL Server Selecting varchar(MAX)

  Hi, Hope I'm in the right forum. Is there some sort of trick to being able to see all the data in a varchar(MAX) column I'm inserting some lengthy data into varchar(MAX) columns. Running the profiler, I can see that long strings are being passed in. But, when I query (to grid, text or file), I only see the very first character. In addition, when I do a SELECT LEN(myVarcharMaxColumn), it returns 1. What am I missing here Thanks, Mike hi, as you can see by the following code, which is quite similar to your declaration, DECLARE @v varchar; SET @v = 'abcdefg'; SELECT @v; a varchar variable declared this way is defined to be 1 byte as no dimension has been specified.. you usually ...Show All

• Visual Studio Express Editions Text box text formating

  hi Everyone, i have a text in a textbox which is amount of something .i.e. 124565321. what i want is to put the commas like 124,565,321 it is just like the way excel do with the number. So please tell me how can i read char by char from the text box and append ' , ' between the char Thank you Take a look at the 'Format'-Function. You can either take a predefined format or you can create your own format Textbox1.text = Format([HereYourString],"D") This is just an example. ...Show All