J J's Q&A profile
SQL Server Adding SCRIPT and LOOK UP components using C#
Hi, Could you please tell me how to add SCRIPT and LOOK UP component to a data flow using C# Also, is there any artilces/site which gives information about the SSIS programming Regards, Gopi Gopinath M wrote: Also, is there any artilces/site which gives information about the SSIS programming from the bol: http://msdn2.microsoft.com/en-us/library/ms136025(sql.90).aspx ...Show All
SQL Server error on server
TITLE: Microsoft Report Designer ------------------------------ A connection could not be made to the report server http://localhost/ReportServer2005 . ------------------------------ ADDITIONAL INFORMATION: Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: -- <html> <head> <title> SQL Server Reporting Services </title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.1399.00" /> <meta name="HTTP Status" content="500" /> <meta name="Produc ...Show All
Visual C# How do I iterate over cells in excel?
I have an excel file, with a bunch of sheets. Each sheet has a table, but there is not certainty of what row the table starts. But I do know the text in the top left cell of the table. So I want to iterate over the cells, until I find that text, then start reading the data. I can't seem to find any documentation for accessing excel document (via excel interop), although I have found tons of snippets, but all doing fairly trivial stuff. So far I have: Excel. Application lExcelInstance = new Excel. Application (); if ( lExcelInstance == null ) { throw new Exception ( "Couldn't start Excel. Is it installed ...Show All
SQL Server Calc Measure Immediate Viewing
This is probably obvious, but.... In MSAS 2000, I could immediately view the new calc measure in Analysis Manager without rebuilding the cube. Is this still possible in SSAS 2005 Can you list the steps Yes you can using the new MDX debugger. When in BIDS, in the caluclaiton tab, create your calculated member and then select the Debug menu and start debuggging. The cube browser will appear just beneath the calculaiton script. You can not only step by step through your various caluclaiton, but you can also change them and see the impact immediately. It is a full fledge VS debugger for MDX... ...Show All
Visual FoxPro COPY TO Command
In Visual Foxpro, I am trying to create a CSV file using the COPY TO command with TYPE CSV, but do not want header fields on top of the output file. Furthermore, I am also trying to attach a COMMA after every row. Current Output f1,f2,f3,f4,f5,f6,f7,f8,f9,f10,f11,f12,f13,f14,f15,f16,f17 "0","49162","0","0","0","0","0","0","0","0","0","0","0","0",2.1, "02/14/2006" "0","49162","0","0","0","0","0","0 ...Show All
SQL Server Restarting server
Why can't i restart my sql server from a client machine even if the login used is 'sa' Restarting SQL Server means restarting the service which needs sort of administrative rights on the computer. Anyway, how did you try to restart the service HTH, jens Suessmeyer. ...Show All
SQL Server SP1 Database Services failed to install
Database services upgrade installation keeps failing when I try to install SP1 on a SQL 2005 Developer edition. This is the log: 04/28/2006 10:35:44.081 Failed to read registry key: PendingFileRenameOperations 04/28/2006 10:35:44.097 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\xmlfilt.dll 04/28/2006 10:35:44.144 Failed to read associated hotfix build information for the following file: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\ThaWBrkr.dll 04/28/2006 10:35:44.160 Failed to read associated hotfix build information for the following fi ...Show All
Windows Forms Deployment: Installation folder & Shortcut problem
New to deploying applications. I created a setup project and it seems to be working for the most part but with a couple little glitches. I need to write a registry value that is the path to the application's database. Easy enough when it installs to the default location, but how do I access the location the user selected if they pick a ...Show All
SQL Server cant connect to server from another machine
Hi Friends I have a sql server (2005 standard edition) on Win xp machine. i can connect to this server from my machine ok but others on the network try to connect i get following error "An error has occurred during report processing. Cannot create a connection to data source 'dataSource1'. A connection was successfully established with the server, but then an error occurred during the pre-login handshake. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 0 - No process is on the other ...Show All
SQL Server How to create an age dimension
Hi I have a time dimension and i'm wondering how to create a dynamic age dimension on SQL AS 2K. It would be very nive to represent an entity by its age or (age interval ).(The age should increase everyday) Can anyone help Regards ...Show All
Visual Studio Express Editions Serious Problem , Need Help Fast
Okay So I installed Vb Express Edition a while ago like 2-3 weeks ago , and i finally got around to making an application, well i started to make it and made it and made it and tested it and tested it , when suddenly i hit the run button and the computer just shut down , the power was on but it like restarted, next i started the program again and did the same thing, but now this time i went to file save and save the soloution and bam the computer did the same thing, so it restared again and then when i logged in there was a popup that said The System Has Recoverd From A serious error so i saw what the contents of the repor ...Show All
Visual Studio Express Editions Problems debugging IE toolbar/deskband in VC# Express
Hi.. I'm Currently developing a toolbar for IE. The toolbar install ok in IE. When trying to select this toolbar from the menu in IE, IE crashes. My toolbar consists of two dlls. The first dll is registered with gacutil and regasm. This dll is used by IE. The second is registered with gacutil and contains some framework code used by the first dll. What I would like to do is to be able to debug these dlls in VC# Express. I know VC# Express is a limited edition of Visual Studio. Is this one of the things that cannot be done Thanks in advance I am also facing the same problem, have yo ...Show All
Visual Studio Express Editions Newbie lost in socket programming with error "An existing connection was forcibly closed by the remote host"
Hello, I'm trying to develop a tcp/ip request forwarder using system.net.sockets and VB 2005 I read somewhere not to use TcpClient and TcpServer for performance concerns... So I've been trying for 2 days without any success with following code. Any help would be really appreciated Dim theIPEndPoint As System.Net.IPEndPoint = New System.Net.IPEndPoint(System.Net.IPAddress.Loopback, 81) Dim ServerSocket As System.Net.Sockets.Socket = New System.Net.Sockets.Socket(Net.Sockets.AddressFamily.InterNetwork, Net.Sockets.SocketType.Stream, Net.Sockets.ProtocolType.Tcp) Dim ClientSocket As System.Net.Sockets.Socket = New ...Show All
Visual Studio 2008 (Pre-release) How can I catch the mouse click event of the header of a ListView?
Hi all, I have the window as show below. < Grid Name = " gr1 " > < Grid.Resources > < DataTemplate x:Key = " Title " > < TextBlock Text = " {Binding Path=Title} " /> </ DataTemplate > < DataTemplate x:Key = " ISBN " > < TextBlock Text = " {Binding Path=ISBN} " /> </ DataTemplate > < DataTemplate x:Key = " NumPages " > < TextBlock Text = " {Binding Path=NumPages} " /> </ ...Show All
.NET Development Windows App Not working over Network
I've got a windows app that connects to a DB and copies a few files from a network share to the local PC. The app is ran on the network share because everybody in our company uses it and when modifications are made, we don't want to have to redistribute 50 or so copies of the .exe. Every time I run the program from the network, I get a standard Windows error and Microsoft wants me to send them the information, it doesn't get too involved other than that. BUT if I run the app from the desktop of the Network box then it runs fine. The network share can see the database and connect to it, so I know it's not that. It must have something to d ...Show All