Answer Questions

• CalgaryDataGirl OPENROWSET BULK ignores FIRSTROW option when format is different

  In SQL Server 2005 I can not get OPENQUERY (BULK ...) to honor FIRSTROW option when the initial rows of a data file have fewer columns than the target area. My problem is that I have a data file with header, data (with column names), and footer sections. Each section has a different format (i.e. no. of tab-delimited columns). FIRSTROW  works well if the header section is stripped out, but I prefer not to have to edit the data file first. If ...Show All

• Joe Horton SSIS error listing

  Is there a list of all the SSIS Error codes and what they mean Ex. -1071607778 is an error code output when a lookup task fails to find a match. I haven't been able to find any information on the different error codes. Is there a description file or enumeration file that exists somewhere The error codes seem stange, they are not hex but they look liek hex. 0xC0202002L is teh value listed, so why the L on th e ...Show All

• Héctor Set in where clause - how to?

  Hi, it seems to me the simplest question. We have a "chart of accounts" and "time" as dimensions, "debit" and "credit" as measures. Time has Year and Month levels. with member [measures].[Current balance] as -- row balance 'measures.[Deb] + [measures].[Cred]' member '[measures].[Total balance] as -- balance in chart of accounts to show 'sum([Time].[Time].Currentmemeber.level.members(0): [Time].[Time] ...Show All

• gocards9999 Find out whether SQL Server services are runing or not - SP4

  Is that possible by querying the SQL Server , to find whether the listed below there services are running or not 1. SQL Server 2. SQL Agent 3. MSDTC No. It is best to do this outside of the database. You can use NT command-line utilities or WMI to do this easily. Let me give some ideas on how WMI ot NT Utilities can be used. For NT Utilities command are referring command "sc". Basically I have 1 ...Show All

• Innovactive Engineering s.r.l. Database Mirroring: Cannot set the Mirror Server instance as the partner on Principle server

  Hi,   I’m trying to get database mirroring working but having problem when principal and mirror are not on the Domain. (I got it working once if both principle and mirror servers are on the domain.) Both servers have fully qualified domain names. Both have Windows server 2003 SP1 and SQL Server 2005 June CTP.   I used Local System Acct/Mixed mode and follow the Setting up Database Mirroring using Certificates article i ...Show All

• Mega_bit_dk ReportViewer usability Problems

  If I put the reportviewer width to 100%, it still does not automatically resize itself. The reportviewer goes way beyond the screen area for lesser resolution screens and you are required to scroll to the right to view the "View Report" button. However, if you look at the report manager, the report viewing area automatically resizes. Anyone knows how this can be done thanks. When you use width in % for ReportViewer on ...Show All

• J.13.Leach Problems with connecting to SQL Server 2005 Express

  Here's my code so far: [source]using System; using System.Collections.Generic; using System.Text; using System.Data.SqlClient; namespace Database { class Database_Main { SqlConnectionString ConnStr = new SqlConnectionString(); public Database_Main() { SqlConnection Connection = new SqlConnection(@"user id=Afr0;password=prins;server=(local);Trusted_Connection=yes;database=Nimdalin;"); Connection.Open(); } ...Show All

• bink142430 Building a Flat File Connector Programmatically

  Hi. After much messing around with the BI studio I've decided that the best way for me to build my FFC is by doing it in code. I've got over 400 columns to define and we already have the position and type information held elsewhere, so it kinda makes sense doing this programmatically. I've read the " Adding Connections to a Package" article in BOL but it doesn't help with the problem I've got. Basically, all I want to do is add columns to a c ...Show All

• Isaac Kunen [264] An attempt was made to send an email when no email session has been established

  [264] An attempt was made to send an email when no email session has been established is the error I get when I try to send mail on the database. It is a SQL Server 2005 Standard edition. I have configured database mail and tested it and it works there, then I configured a database operator. then I just created a test job to notify the operator of the job completion, and the email fails. Any ideas Ryk I go ...Show All

• r_sendhil PDF Export has "line" in Chart

  When I export a report to pdf format the charts in the report have a thin white line down the middle. Has any one else seen this and is there a fix ...Show All

• updates Problem installing SQL Server 2005 Express with Advance Services CTP

  Hi, I was unable to install the CTP version of SS Express Edition SP1 with Advance Services. The installation failed with the following error message: TITLE: Microsoft SQL Server 2005 Setup ------------------------------ SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for mor ...Show All

• ancernet The system could not verify that the destination supports secure storage capability

  I am trying to save my package (using MS Visual Studio) with ProtectionLevel = ServerStorage but it is failing with the following error "failed to apply package protection with error 0xC0014061, the protection level, serverstorage, cannot be used when saving to this destination.  The system could not verify that the destination supports secure storage capability...".   I am trying to test a scenario on which the package ...Show All

• Old_One how to sum a column depending of another colum into different vars?

  Hi all, I am trying to sum a column into different variables depending on another column. Let me explain my self better with an example DECLARE @Initial decimal(18,2), @incomings decimal(18,2), @outgoings decimal(18,2) SELECT @initial = CASE WHEN type = 1 THEN SUM(amount) END, @incomings = CASE WHEN type = 2 THEN SUM(amount) END, @outgoings = CASE WHEN type = 3 THEN SUM(amount) END, FROM Transactions WHERE date = '05/14/2006' AND STATION = 'apuy ...Show All

• zieQ Develop multiusers applications with SQL Server Express

  Can I develop applications with SQL Server Express that I have more than one user in several computers working with the same database on a server, or I can only develop applications with only one user with a local database with SQL Server Express You should also read the Blog entry at http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx . You may need to enable SQL Browser and create Excpetions in y ...Show All

• MS makes it difficult Assembly Clash between June and July CTP in VS.NET/SQL Express

  Hi!  How do I upgrade the assemblies in a databases between the Framework that came in VS.NET June CTP and VS.NET July CTP.  I've created a fairly extensive database in the former which I'd like to use in the later.  All of the non-CLR stuff seems to be accessible just fine.  Unfortunately I no longer have the June CTP installed and the assemblies are running into versioning problems.  I'd be happy to delete the offendin ...Show All