satya n's Q&A profile
SQL Server Transfer Database Task
I am attempting to utilize the 'Transfer Database Task' to copy a SQL 2000 database to 2005. I would like to set up the task as a job to run nightly and update the 2005 database from 2000. I have the DestinationOverwrite set to true, the Action set to Copy, the Method is DatabaseOnline. I receive the following message... ERROR: errorCode=-1073548784 description=Executing the query CREATE ROLE[RSExecRole] failed with the following error: "User, group, or role 'RSExecRole' already exists in the current database..." If I set overwrite to true...why is this an issue Suggestions Comments Thank you ...Show All
Visual Studio What happened SourceSafe web service access in Beta 2?
A collegue of mine has just setup a SourceSafe 2005 database and configured it for internet web service access. I have Team Suite installed including SourceSafe 2005, but I am unable to find an option anywhere which would allow me to connect to it. I can connect over a local LAN or over the net via file sharing, but I can't find the web service protocol. I was informed this feature was in Beta 1. Anyone know what happened to it I thought Beta 2 was feature complete since the Go Live license is available.... Now i managed to get it to work. I had enabled the internet access while the proj ...Show All
Visual Studio Tools for Office Macros in Excel for Exporting Tables to Excel
Hi, For my ICT coursework I have created a series of table in Access and I have decided to create a macro that exports the tables to excel. I have managed to create the macro but it will not work because it is on an OLE sever. Could you tell me how to make it work Also would I be able to make this macro work when I am in Excel So I would have a macro button that exports data from Access, and it would be executed in excel. If this was not possible, is there any way that I could create the macro in excel and import data from Access Any help would be greatly appreciated. Annie Hi Annie: You ...Show All
SQL Server Excel Objects From SSIS
I'm trying to use Excel objects from within an SSIS Script Task but I can't figure out how to add a reference the object library. I'm using Excel 2003 and tried Add Reference from the Project menu but there is no entry for Microsoft Excel Object Library or Microsoft Excel 11.0 Object Library. Any suggestions Thanks. That's a lot of overhead to invoke excel.exe, and discouraged since packages often run unattended. I would (1) use the Export Wizard to create the destination spreadsheet file initially or (2) save a blank one somewhere as a "template" and use a Script task (for example) to make ...Show All
Microsoft ISV Community Center Forums html tag not working
Anybody can tell me why the COLGROUP tag below does nothing to my table Sub send_email_confirm() Dim objMail As MailItem Set objOL = New Outlook.Application Set objMail = objOL.CreateItem(olMailItem) ' determines if sale or purchase Dim side As String If Sheet2.Cells(6, 8) < 0 Then side = "Sold at " Else side = "Bought at " End If With objMail .To = " tradeallocations@trade.com " .CC = "trade" .Subject = Sheet2.Cells(1, 3) & ", " & Sheet2.Cells(1, 2) .BodyFormat = olFormatHTML .HTMLBody = "<HTML><BODY><B>" & sid ...Show All
.NET Development Xsl debugger in VS 2005
I was wondering if it is posible to use the xsl degugger when I am calling C# functions from my xsl script Yes, you can step from C# into XslCompiledTransform, and from the XSL directly into and out of the script blocks (all thanks to the power of the CLR). ...Show All
Visual Studio 2008 (Pre-release) How to use XPSViewer in Win32 based applications
hi: I have a few qeutions to ask : a)Our company's software(win32 based application) would spport xps file format, viewing and wirting the xps file. Could the XPSViewer be embeded in own software to view the xps file if can do, how to do If can't, how to support to view the xps format file b)What are difference between win32 based application and WPF application Could I use the new API classes under win32 based application such as DocumentViewer, XpsDocument and so on. We will be shipping an out of band native code based viewer. This viewer will implement Windows' iPreview interfaces. You can us ...Show All
Visual C++ how to save html file in VC++
hi, i want to save a html file from my browser. i have created my own browser and want to save the html file.. i have used ACTIVE X controls to make my own web browser(same as IE).. it should be like that of SAVE AS option of IE.. plzzhelp.. Just Google. I C++ i don't know. You need to code yourself and learn how it is working. Sometimes it is hard work :-) Bye Martin ...Show All
Visual Studio Express Editions Install of Visual Basic Express fails
I keep getting the same error when trying to install Visual Basic Express. The installer errors on Microdoft Windows Installer 3.1 then stops. Anyone have experience with fixing this I've tried downloading and also using the disk image same result. Windows 2000 professional service pack 4 Error occured during setup The following component failed to install: Microsoft Windows Installer 3.1 The following components were not attempted Microsoft.NET Framework 2.0 Microsoft Visual Basic 2005 Express Edition -ENU This happens no matter how I try to install via downlod or manually. ...Show All
SQL Server Automatic synchronization of lookup columns
Data Flow: Step 1: I use a OleDb Source Task to read data from a table (say table A) with 5 columns. Step 2: Then I use a lookup task to add a sixth column (resulting from lookup on table B). Step 3: Then I save the 6 columns to table C using a OleDb Destination Task. Now, I go to underlying database and modify the tables like: - remove 1 column from table A (not the column used for lookup later). - remove 1 column from table B (not the columns used for lookup and not the columns retrieved after lookup) - remove 1 column from table C (same as the one removed from table A). If I get back to SSIS designer, it is nice enough to ...Show All
Visual Studio 2008 (Pre-release) tests and Linq
Hi all, I am writing a class to explicit the Tree structure of expression tree (hence enabling visitors etc..), and I thought it would be good to use those nice testing feature from VS2005. But when in my testing code I define an expression, I get the following error : Test method DataStructureTest.ExpressionTreeTest.ChildrenTest threw exception: System.InvalidProgramException: Common Language Runtime detected an invalid program.. In this method lies only : [ TestMethod ()] public void ChildrenTest() { Expression < Func < int , bool >> exprLambda = (x => (x & ...Show All
Microsoft ISV Community Center Forums download a file via internet and save it locally
Hi, I would like to have a script that download a file (a word document) from internet (http/https) and save it on local PC. I've already found how to download a file: ************************************************************ Dim WinHttpReq Set WinHttpReq = CreateObject("WinHttp.WinHttpRequest.5.1") WinHttpReq.Open "GET", "http://", False ************************************************************ but then, I don't know how to save this file on my PC :( Anyone has an ideea Thank you, (Paul) Per one of our support engineers: This is the vba code to download a file from an URL, then save it to ...Show All
.NET Development ThreadState::Aborted
I have got a small problem with ThreadState. The next sample will illustarate it. I am using Visual C++ .NET 2005 but it's easy to translate this sample into C# or into VB. #include "stdafx.h" using namespace System; using namespace System::Threading; void foo() { while ( true ){ Console::WriteLine( "test" ); Thread::Sleep(1000); } } int main() { Console::WriteLine(L "The thread is starting" ); Thread ^oThread = gcnew Thread( gcnew ThreadStart(&foo)); oThread->Start(); Console::WriteLine( "Press any key to abort the thread" ); Console::ReadLine(); oThread-& ...Show All
SQL Server Dynamic (Parameterized) Page-Breaks
Hi, I have a report, where depending on a parameter-value (e.g. Change in day: Yes/No), I need to display the records in one page or multiple pages (i.e. If Change in Day = Yes, display the records for each day in different pages. If No, display all the records in one page). In-short page break for each day, if there is a change in day, else no page break. Can anyone suggest, is this possible to do with SSRS 2005 RTM I had read somewhere that conditional page-breaks is not supported. But, is there any other way I can do this Thanks in Advance. Isnt there a way to achieve this Its URGENT. Any h ...Show All
Windows Forms windows application with SYSTEM account
here i have aproblemm. that is how can my windows appication run in SYSTEM user account which will come defaultly with OS.. My application will need to run in this SYSTEM user only how can i accomplish this please let me know any issues Hi, Is it a web app or winforms app what's the error description its throwing when you are trying to run on system account Thank you, Bhanu. ...Show All