PQSIK's Q&A profile

• SQL Server Execute Process Task Arguments

  HI, Is it possible to provide variables ( multiple variables ) in the arguments parameters of the Execute Process Task Thanks Shafiq ...Show All

• SQL Server Sample code for creating and processing a Partition with AMO

  //===================================================================== // // Summary: Sample code for creating and processing a partition in // the "Adventure Works" Analysis Services database. // //--------------------------------------------------------------------- // // Copyright (C) Microsoft Corporation. All rights reserved. // // THIS CODE AND INFORMATION ARE PROVIDED "AS IS" WITHOUT WARRANTY OF // ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO // THE IMPLIED WARRANTIES OF MERCHANTABILITY AND/OR FITNESS FOR A // PARTICULAR PURPOSE. // //===================================================================== using System; using Microsoft.AnalysisServices; namespace Microsoft.AnalysisS ...Show All

• Windows Forms How can I make a panel's Opacity 50%?

  How can I make a panel's Opacity 50% so that some of the background shows through Thanks, I created a True Color 24-bit image in MS Photo Editor, colored it a gray tone, set the transparent color to the gray tone with 50% transparency, saved it as a PNG, set it as the background picture on a panel, and it was not 50% opaque. Did I do something wrong ...Show All

• SQL Server SSIS refresh fails

  When I use the OLB data source (SQL SERVER 2005), select * from tableA, then use several steps and then Union ALL and Fuzzy Match, the process works fine. When I change the data source SQL to include two tables with a cross join, the new fields in Table B do not appear in the Union ALL or Fuzzy Match steps but do appear in all steps prior. The advanced editor refresh does not fix the problem. Deleting and recreating the Union ALL shows the Table A and Table B fields. Fuzzy Match is still incorrect. Deleting and recreating Fuzzy Match fixes it. Thanks for the help. I'll read in the Wrox book. There seem to be more issues with refresh not picking up the metadata or I'm using it wrong. When I create d ...Show All

• Visual Studio Team System RTM: Build Type running Test List always fails test

  Im adding unit tests to our Build Type. Whenever, I run it always fails the tests. I dont understand why. Is there a trick to running Unit Tests in a Build Type This is the output in the log: Target CoreTest: Creating directory "C:\MARS_Daily_Build\MARS_Platform\SSMARSSmokeTest\BuildType\..\Sources\..\TestResults". __________________________________________________ Project "C:\MARS_Daily_Build\MARS_Platform\SSMARSSmokeTest\BuildType\TFSBuild.proj" is building "C:\MARS_Daily_Build\MARS_Platform\SSMARSSmokeTest\BuildType\TFSBuild.proj" (RunTestWithConfiguration target(s)): Target RunTestWithConfiguration: TestToolsTask MetadataFile="C:\MARS_Daily_Build\MARS_Platform\SSMA ...Show All

• Visual Studio Express Editions Fundamental doubts on DLLs and Lib files on Windows

  Hi, I am a Solaris developer trying to port an application to windows using Visual C++ Express Edition and SDK. The application can be briefed as a module for Apache 2.2. The output I want is a DLL which has a function which will be called by a module in Apache. I have a core set of files which I compile to a static library A.lib. Then I have another set of business logic which uses A.lib and the output is B.lib. Around B.lib I have a set if interface methods which I want to publish as exported function in a shared library say C.dll. When I build I get the size of A.lib < B.lib. I want total logic as a single DLL C.dll and expect it bigger than both A.lib and Blib. But the size is A.lib around 5 MB, B'lib around 4 ...Show All

• Visual Studio Team System Team Build with Multiple Projects fails to build.

  I have Project Solution containing 3 Projects 1. Web Service Application.[refers some 3rd party assemblies] 2. Class Library Refered by Web Service Applicaion. 3. Test Harness Project depending on Class Library. It successfully compiles on TFS Server using IDE. But when i try to build this solution using Team Build it fails. It fails saying cannot find " OBSBusinessRuleFunctions.dll " which is 3rd party Assembly. I have tried various options for Build like 1. Any CPU [This build successfully but doesnt copy web services related files and Assemblies.] 2. .Net [Fails to build stating cannot copy few of the assemblies...error message: error ASPCONFIG: Could not load file or assembly 'OBSBusinessRuleFunctions, ...Show All

• SQL Server SSIS and SSAS projects in one solution

  Hi, I would like to add some related SSIS and SSAS project into one solution in BI Studio. I opened one empty solution, but when I add the first project the option for adding a project to solution isn't there anymore. I'm I missing something or this just can't be done txh for answers! JAnez Hi Mary After adding the first project to solution, the solution node disapperars. However the option via File menu works fine. Thx! ...Show All

• SQL Server SSAS YTD with Multisets

  Hi All, I'm not that well versed with MDX (I'm more of a TSQL guy). I have a simple calculated member as below: AGGREGATE ( PeriodsToDate ( [end_date].[Financial].[FYear] , [end_date].[Financial].CurrentMember ), [Measures].[ActualVolume] ) This works fine if I filter on the year or a single period, however it fails if I try any mltiset selections (for example 2 quartuers). Any help would be appreciated. thanks, Hi, I managed to get this far: SUM ( EXISTING [end_date].[Financial].[FYYYYMM]. Members , SUM ( PeriodsToDate ( [end_date].[Financial].[FYear], [end_date].[Financial]. CurrentMember ), [Measures].[ActualVolume] ) ...Show All

• Visual C# VS.Net too slows down after first debug attempt

  Hey Guys, I hope Someone can help with this issue. after running any project made with C# my IDE slows down to the point where I can not type a single word without waiting for 5 to 7 seconds between words, some times typing "this" takes 7 seconds. I am using XP SP2 with VS.Net pro 2005 SP1 OS is 32 Bit XP and processor is 64 bit AMD. Memory is 1.5 Gig this is a fresh install So far I have disabled all Macros, deleted, Recent files from registry disabled Track Changes under thhe options menu. still when I open any project I can type code fine without any problems but after I debug the project it slows down again and I have to restart VS.Net to be able to type normally. This is using Windows Forms not webforms Thanks ...Show All

• Visual Studio Team System Task Duration MS Project vs. VSTF Task

  The task duration in MS project is in days. I use man hours in my Team Project tasks (work items). If I say something will take 20 man hours, MS Project sees that at less than a day. What does one do to make more sense of this inside MS Project Good find! By the way, we have a fix for this issue. if you would like to continue using commas in the resource names, call CSS and ask them for the free fix for this issue. Good luck! ...Show All

• .NET Development Please help -specified cast not valid -Helloword example

  Hi am delving into webservices and encountering little chaos that i need to make them as my stepping stone with your help. i have a Hello worldwebservice project which has thesoapextension & encryption dll . my webmethod looks [WebMethod] // [a1.EncryptionExtension(Encrypt=a1.EncryptMode.Response)] //commented public string HelloWorld() { return "Hello World"; } ------------------------------------- proxy class created using wsdl looks below and i included this class file to my webclient that calls the above webservice public class service_Traceext { [System.Web.Services.Protocols.SoapDocumentMethodAttribute(" http://tempuri.org/HelloWorld ", RequestNamespace=" http://tempuri.org/ " ...Show All

• Smart Device Development New version V4 of C# IDE Mobile (former C# Scripter)

  New version V4 of C# IDE Mobile (former C# Scripter) C# IDE Mobile is an application (totally free) that I've developed to be able to develop with C#/.NET2CF directly on the Pocket PC/Windows Mobile 5 (it doesn't require the .NET SDK, you don't need a computer). You can download the new version at: http://www.geocities.com/hrowson/wm5_software/index.htm or from my personal page: http://www.geocities.com/hrowson/index.htm This new version mainly adds the following improvements: - Handling of "try/catch" error control with "throw" exception rising - Added management of "using" directive - Function exit with "return" is now possible - Implementation of loop control flow keywords "break" and "continue" - Reorganised the me ...Show All

• Visual C# Send and Retrieve files to Database

  hi again... This time i'm stuck on an issue concerning sending and retrieving *.exe files to and from a SQL database. Code to send: FileStream fs = new FileStream (FileName, FileMode .Open, FileAccess .ReadWrite); byte [] MyFile = new byte [fs.Length]; fs.Read(MyFile, 0, System. Convert .ToInt32(fs.Length)); fs.Close(); dAdapter = new SqlDataAdapter ( "Select * from system where id=1" , cnn); SqlCommandBuilder command = new SqlCommandBuilder (dAdapter); DataSet ds = new DataSet ( "system" ); dAdapter.MissingSchemaAction = MissingSchemaAction .AddWithKey; dAdapter.Fill(ds, "system" ); DataRow row; row = ds.Tables[ "system&quo ...Show All

• SQL Server Login information does not reflect correctly after rename.

  Hi all, I’m converting some application to SMO but I’ve run into a snag . I initiate the SMO connection (SMO.Connection) and create the SQL server (SMO.Server) when the form is loaded. I enumerate all the logins on the SQL server. By using the login information I retrieve the mapped username of that specific login. E.g. Login “User1” with mapped username “Test user” on “Database1”. I keep the connection   (SMO.Connection) as well as the server connection (SMO.Server) open without resetting it. I rename the login account to “User2” (SMO. Login.Rename("User2") ) and the mapped user to “Test user2” (SMO.User.Rename(Test user2) ) .   Here is where things get funny. When I enumerate the information again the mapped user name ...Show All