Answer Questions

• Deadlock42440 Absolute Beginner Questions

  I just downloaded and installed Visual Basic Express Edition and SQL Server Express Edition. All I have in the Start menu is SQL Configuration Tools. My absolutely stupid question is, how do I get started with this I know a little bit about SQL from using SQL command line in Oracle, and I've built small databases before using Access. Where does this program fit into all of that And what do I use and how can I get started with this program ...Show All

• Mike Kulikowski Could not load file or assembly

  I am receiving the following message when I try to create an SSIS project in Visual Studio 2005 Team Suite: Could not load file or assembly "Microsoft.AnalysisServices.Controls" Version=9.0.242.0, Culture=neutral, Public Key Token = 89845dcd8080cc91 or one of it's dependencies. Strong name validation failed (Exception from HRESULT: 0x8013141A) Thank you Larry Geiger It is just that these projects are registered in VS, b ...Show All

• wojtas_a Minium Permissions necessary to create a login?

  What are the minimum permissions necessary to use CREATE LOGIN I'm using db_accessAdmin and db_securityAdmin and db_owner. The user as access to the database. It still says I can't create the login. What am I missing The answer is in Books Online: http://msdn2.microsoft.com/en-us/library/ms189751.aspx "Requires ALTER ANY LOGIN permission on the server. If the CREDENTIAL option is used, als ...Show All

• Yury P Higher Level Edition Error Message

  Hello all, I just installed the June CTP Client Tools on a fresh hard drive (no previous CTPs installed).  I am trying to run a package that was written in the April CTP and runs successfully on other computers with the June CTP installed. When I run the package, it fails on an 'Execute Package Task', and I get the error message: "The task cannot run on this edition of Integration Services.  It requires a higher lev ...Show All

• Vijaye Raji Output format

  I'd like to take the results of my report and save them as tab delimited text files.  This is not one of the options available when I click the save button.   The only options I have are XML, CSV, TIFF, PDF, Web Archive and Excel. I'm new to this software.   Any help would be appreciated. TIA, Paul Hammond Richmond, VA I'm not sure what you mean by URL access. Paul Thanks, All this sounds like a lot more work ...Show All

• TetsuKaben Need distributed service broker sample

  I'm working with the April CTP of SQL Server and I'm trying to create a proof of concept using service broker.  I'm struggling with the "abc's" of it.  If anyone has or can point me to a distributed "Hello, World" for service broker between SQL Server 2005 and SQL Express instances it would save me some time and trouble. thx! OK - I've run through the sample.  I am much more enlightened but stil ...Show All

• Javarja Report Services

  Configuring sql services is a nightmare. Why it seems like the tools to configure it are quirky and don't work as advertise. Anways, I've spent the last two weeks trying to set up remote reporting. The following list are a few issues I ran into and what I did to get around them. Hope this helps. Tip : If possible, don't every mess with the report server virtual directories (like recreating them), you'll end up with a permissions nightmare. Iss ...Show All

• j2associates ODBC Data Source error

  As other contributors, all I am trying to do is import data from an ODBC source (spelled 'non-Microsoft data source') into a SQL 2005 table. I can easily do this in SQL 2000 with DTS, but when I use the same DSN in VS 2005 it doesn't work. I created an integration project, and made a connection in Connection Manager to the DSN and clicked Test Connection. It succeeded, or so it claimed. Click OK and drag a DataReader Source onto the Data F ...Show All

• Shawn Clark PIVOT question

  I have a basic table consisting of several thousand records. Im trying to generate a pivot query for a report. the table consists of records, each of which has a recieved date ( small date time ) and a tranactioncount ( int ) . Im looking to generate a PIVOT to show the show the month and year counts for the files recieved ie YEAR | JAN FEB MAR APR etc 2004 ! 2 34 67 43 2005 | 12 2 3 1 can anybody ex ...Show All

• RensV Is Ad hoc reporting compatible with Web Applications

  We are planning to imlement ad hoc reports in out application but somebody said that, it supports only Windows based applications. Can we access Report Builder over the internet can anybody pull me out of this question "The clients must have .net framework 2.0 installed on their machines." Is this true I didnt think this was the case.... Luis, Thanks for the reply. i think Report builder is a windows ...Show All

• Rebecca Karma SSIS Fuzzy Matching

  Is there any way to use fuzzy lookup functionality (that exists in SSIS) in your .Net code   I want to call a .Net class rather than calling an SSIS package. Thank you. -- AK The real issue here as I see it, is people want to leverage the Fuzzy routines, particularly lookup, for Web/Win form applications. Data entry type scenarios where you could use the lookup to find existing entries that “look like the one I have here” to s ...Show All

• Clare North "command line parameters are invalid " is the output for a SQL job to run SSIS package

  Hello, I created a SSIS package that has a flat file manager whose connection string is a package variable, the reason is that there is a foreachfile container loop to loop thru CSV format files in a directory and load them to a sql table. The package execution is working in the designer studio as well as in the management studio-- a copy was saved to a sql 2005 server where a sql job is deployed to run the package. However w ...Show All

• dotnetJava Default SqlServer database creation path

  Hi, How can i get default sql server(2005) database creation path using Tsql/ or system stored procedure in previous(2000) i used undocumented sp(sp_MSget_setup_paths) to doing this. Thanks Dishan it return empty result set... im not set specific path for data/log when installing sql2005. Hi, your post has been useful in pointing me to the right direction but I cant get xp_instance_regread to return a result set where the registr ...Show All

• Reza Chitsaz - MSFT What does the componentMetadata.FireError method do?

  Could some one tell me ComponentMetaData.FireError(),ComponentMetaData.FireWarning() will Do will it write into a event log or Does it show a Message Box to the User. ComponentMetaData.PostLogMessage() where does it Log the message passed as parameter to this method Thanks in advance. FireError()/FireWarning()/etc ... raise events that can be captured by both eventhandlers and your logging mechanism. Events get raised co ...Show All

• Tom_MTB <Code>-8462</Code>

  Hi: My service broker is working with 2 different instances in local server.But could not able to get working on 2 different servers because of Conversation ID cannot be associated with an active conversation error which I have posted. After I receive the message successfully...in the end I get this message sent... < Error xmlns = " http://schemas.microsoft.com/SQL/ServiceBroker/Error " > < Code & ...Show All