MoP73's Q&A profile

• SQL Server Assign a value to a variable without using SQL Task

  Greetings once again, I am trying to achieve a seemingly simple task of assigning datetime value to a user variable at the point my package starts running. How can I do this without using a SQL Script Task Should I be using a script task for this or is there a simpler way to achieving the same thing Thanks in advance. ...Show All

• Visual Studio Team System How to deny/prevent overriding Check-in policy

  Hello, all I've created a new check-in policy, which does not allow checking in anything without any comments. It works well, but the user still gets the Policy Failure window that gives an opportunity to override policy failure, I don't want this window to appear and more than that, I don't want users to override check-in policy.                                                                      ...Show All

• SQL Server Is it Possible?

  Hi, As part of a DB migration, I have a case wherein the data between domain and trnsaction tables is not consistent, and those sort of records I planned to move it some unknown bucket. say there are two tables, Master and Transaction. then my query will be, Select isnull(master.SurrogateKey, 1) From Transaction Left join master On (transaction.naturalkey = master.naturalkey), every master table will have a record with ID 1 which will inturn be Unknown, so all the non matching records in the transaction table will automatically be pushed in the unknown bucket. Thanks for reading this long :) Now my query is when i plan to use SSIS, how to achieve this sort of requirement Is this possible u ...Show All

• Visual Studio Team System Item.DownloadFile not returning correct version?

  This is the code I have: Dim item As Item = versionControl.GetItem(file, VersionSpec.ParseSingleSpec(version, Nothing)) Dim fileName As String = file.Substring(file.LastIndexOf("/"c) + 1) item.DownloadFile(Path.Combine(folder, destFileName)) I wanted to see what would happen when I tried to request a version that does not exist for the file in question. In my case, I entered version as 6050. It did not throw any exception but returned 6038, which is the previous version that exists in TFS. I suspect I am using the incorrect method in VersionSpec. Can someone verify this I don't know the details of how you should set up a trusted domain, but I'll bet that's the problem. If the server can't talk to active director ...Show All

• SQL Server How to maintain alternating row background colors while making blank rows invisible.

  I am currently checking textbox values to see if they are blank and then setting the hidden property to true. This however disrupts the flow of the alternating row bgcolor. How can I maintain the alternating row colors Thanks I am using an Analysis Services cube as the data source and the report also has a few calculated columns. It is when all of the columns in the report are '0' then I want them to be left out/hidden. Based on my limited knowledge, I don't think that is possible from the cube side but if I am wrong please let me know. Thanks ...Show All

• Software Development for Windows Vista Issues with HumanEmailWorkflow...

  Hi Everyone, I am having serious problems with HumanEmailWorkflow - a "Sample" as from Windows Workflow Foundation. These are the errors I am getting: Warning 1 Could not create output directory 'C:\Windows Workflow Foundation\Examples\SimpleHumanWorkflow\RtcActivityLibrary\bin\Debug\'. Access is denied. RtcActivityLibrary Warning 10 Cannot find wrapper assembly for type library "Outlook". SmtpMailServices Warning 11 The referenced component 'Outlook' could not be found. Error 2 'LeaveWorkflows.EmailWorkflow' does not contain a definition for 'CanModifyActivities' c:\Windows Workflow Foundation\Examples\SimpleHumanWorkflow\LeaveWorkflows\EmailWorkflow.Designer.cs 43 18 Error 3 'LeaveWorkflows. ...Show All

• SQL Server How to remove Projects and reports from web browser

  I am creating, building, and deploying reports via a web browser interface in SQL 2005 Visual Studio. There are a few projects that I no longer want the masses to see when the go to \\servername\reportserver . I have deleted all files associated with the projects and reports, and removed them from within the report server, but when I open the web browser I can still see the old projects and open the reports. Where is the browser getting this information even though the data doesn't even exist as far as i can tell, and how to I actually delete those entries that i no longer want seen. I have heard that I can go the actual web page itself, and delete the items using "show details", but I am unfamiliar with where exactly that ...Show All

• Visual C++ Has anybody the demo program which has a combox which can select all of the country in the world?

  Has anybody the demo program which has a combox which can select all of the country in the world The most importance thing is that it has to including all the country and regions. I apprecaite your help. These type of questions are outside the scope of this forum ...Show All

• SQL Server Errors in the metadata manager

  Hello, I'm trying to process a cube and i'm getting the following error message. I'm not working in Analysis Services Project 4, i created another project. I deleted Analysis Services Project 4 and every project i try to execute i get this error message. "Error 1 File system error: Error opening file; \\ \C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project4.0.db\TBLE~MC.0.cub.xml is not a disk file or file is not accessible. Errors in the metadata manager. An error occurred when loading the TBLE~MC cube, from the file, '\\ \C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\Analysis Services Project4.0.db\TBLE~MC.0.cub.xml'. File system error: The following error occurred while writing to the file ...Show All

• Visual Studio Team System Question about CA2000

  I have some questions about the CA2000 rule. We are using VS.NET 2005 and the following piece of code is a simplified version of our current problem: public class Formatter : IDisposable { public void Dispose() { } public void Foo() { } public void Bar() { } } public class MyClass { /* * This should raise a CA2000 error since the local variable formatter isn’t disposed. * => No error is raised. */ public void Execute(bool home) { Formatter formatter = Create(home); formatter.Bar(); } /* * This shouldn’t raise a CA2000 error since the formatter is returned to the caller * of the function. * => An error is raised. */ public Formatter Cre ...Show All

• Commerce Server Report examples using Analysis services and reporting service

  Hello Are there any examples of Reports using Analysis services and reporting service Thanks arik Hello arikve, Concerning reporting services You have many samples (rdls) in your commerce server 2007 base installation directory (RDLs\ your language\ subdirectory example C:\program Files\Microsoft Commerce server 2007\RDLs\EN\). Concerning analysis services, if you have an existing commerce server 2007 web site installed on your server , you can access to your cubes through sql server analysis services and choosing your relevant database. You must have installed your data warehouse database before. If you have no commerce server web site, install the starter site. You can access the reporting services rela ...Show All

• Silverlight (formerly WPF/E) Is there any way to show the XPS's XAML?

  Hi, I'm looking to convert from PPT file to XAML(WPF/E) type. Is there any nice way to covert from ppt I found that XPS is a subset of XAML. At first, I was very happy to find that. But, It has three problems. ----- This code is made by XPS Document Writer ---- <Canvas RenderOptions.EdgeMode="Aliased" > <Path Data="M 81.12,36.8 L 1041.12,36.8 1041.12,397.76 81.12,397.76 z" Clip="M 81.12,36.8 L 81.12,396.8 1041.12,396.8 1041.12,36.8 z"> <Path.Fill> <ImageBrush ImageSource="/Documents/1/Resources/Images/5.JPG" Viewbox="0,0,1024,385" TileMode="None" ViewboxUnits="Absolute" ViewportUnits="Absolute" Viewport="81.12,36.8,960,3 ...Show All

• Silverlight (formerly WPF/E) MediaElement and straming mms

  Hello guys. I know that on a wpf app i can use MediaElement to stream mms content. can that be done with wpf/e too i've tried setting the Source attribute on xaml and with jscript code but i allways get an empty window. thanks. ...Show All

• Visual Studio build skipped because Configuration isn't evaluated right

  Done executing task "MSBuild". Task "MSBuild" skipped, due to false condition; ( ('$(Configuration)' == ' Release') and ('$(Platform)' == 'Any CPU') ) was evaluated as ( ('Debug' == 'Release') and ('Any CPU' == 'Any CPU') ). this is the command line: C:\sandbox\IAF.NET\IAF\trunk\src\BOs\Error>"C:\WINDOWS\Microsoft.NET\Framework\v 2.0.50727\msbuild" /v:diag the default config is Debug. I have tried forcing the configuration with /p:Configuration=Debug but that doesn't change the output. What am i missing ...Show All

• SQL Server Restart of SQL Server Agent needed - every day

  Hi, I'm having a very strange problem here. I've got a few SSIS-packages here which runs as Server Agent Jobs. They are scheduled to run every hour. This is what happens: on the first run, all packackes are running and completing all steps successfully. After that, at the second start of the jobs, activity monitor shows "executing step 1", but nothin happens anymore. To get the jobs running again, I need to restart SQL-Server Agent Service. I really have no clue whats wrong with my agent. Any suggestions/hints Regards, Jan Use the logging functionality in the SSIS packages to see which FLow task is making problems and is probably slowing down or freezing the system. HTH, Jens K. ...Show All