Answer Questions

• Dhiraj Thakur Looping through an excel spreadsheet

  Being new to SSIS I wish to loop through a series of excel spreadsheets and within each workbook loop through each sheet. I am aware of the For Each container but how can the each sheet in the workbook be referenced Steve You need to use an ADO.NET Connection Manager, the Jet Provider, and on the All page of the editor, enter "Excel 8.0" as the value of the Extended Properties argument. -Doug ...Show All

• Yawei Report Model in VM environment

  What are the limitation when creating report models in VM environment Jon - Correct, I was refering to "Virtual Machine/Server". When trying to create report models that sits on "Big" tables, it happens very often that I get "Timeout Error" which usually occurs after 5min. All the timeout parameters in Data Source are set to zero but it still happens. Thanks ...Show All

• Folyjon Login failed for user <<domain>>\<<server name>>$

   am working on asp application which basically is an interface to the report server. I am currently unable to determine the source of the problem so it may have nothing to do with reporting services. Currently the back in off this application consists of a reports and web server on a machine named tango and a SQL database server on a machine named tango. The SQL logs show a failed login for user organization\polo$ (organization is a ma ...Show All

• Wentzel INSTALLATION PROBLEM OF SQL SERVER

  Hi all,   I had an older version of sql server 2005 i.e. 9.00.16 or something like that...but for my work i had to use the newer version of it i.e. 9.0.1314.6...so i uninstalled everything by now from the previous version...now in my ADD/REMOVE PROGRAMS i have : Microsoft .net framework 1.1 microsoft .net framework 1.1 hotfix microsoft visual j#.net microsoft visual studio .net enterprise architect 2003...and MICROSOFT .NET FRAMEWORK 2.0 BE ...Show All

• kalyan_krishna 2005 encryption - symmetric keys

  Hi There We have been playing around with encryption in 2005. I cannot find a BOL topic that discusses dropping encryption objects such as keys. We do the followign steps: Create master key with password, then we create a certificate using the master key, we then create a symmetric key using this certificate and encrypt data columns. But what i find worrying is that you can then drop the symmetric key , there are no warnings that ...Show All

• lbeham Analysis Services through Management Studio: cannot connect. Possible workaround.

  I have a SQL server 2005 developer edition installation on my Windows XP SP2 workstation. SQL Server was installed after Visual Studio 2005 pro, and therefore after SQL Express. From what I recall, SQL Browser was also installed with SQL Express using the Local System account as the Browser service account. As per best-security practice, I have installed 2005 developer edition with the accounts for the services as local accounts (different acco ...Show All

• Palia Weel Error (rsInternalError) after installation

  I have installed Reporting Services 2005 64bit Enterprise Edition on WIN 2003 64bit SP1 Enterprise Edition. Reporting Services Configuration Manager indicate that everything is ok, green checks except Encryption Keys and Execution Account. Reporting Services databases, ReportServer and ReportServerTempDB, is not "installed" at the same server. Tha DB's runs at a SQL 2005 Server 64bit in the same domain. I get following error: http:/ ...Show All

• Tamama beginner question - instances VS. separate databases?

  Hi, I hope this is the right place to ask this question. I'm trying to get started programming databases against SQL Server Express. I'm pretty confident in understanding the techniques of how to access a database, a specific table, retrieve rows, etc. However, I’m having endless frustration in understanding the very rudimentary basics of how the SQL system even works. I know I don’t need this information to program against it on a sim ...Show All

• Edmundas The connection manager 'OLEDB' is not properly installed on this computer

  Please help someone from MSFT! I've just finished installing the Sep CTP on my laptop.  I previously had the April CTP and June CTP.  I followed the instructions for removing a previous installation of SQL 2005. Now, when I try to create an SSIS package, I get a message that says: TITLE: Microsoft Visual Studio ------------------------------ The new connection manager could not be created. ------------------------------ ADDITIONAL IN ...Show All

• CharlemagneJunior console apps only work if user is SA

  Hi When I try to use a user other then SA my console apps don't work. I can run the Stored Procedures used in console application from Query analyser when logged in with the username/password that I'm attempting to use for the console applications. Under Users in Enterprise Manager Database access is 'permit' for my user. By the way my web application which uses the same user name and password as in console applications is working . I al ...Show All

• scottmclean Best way to make a database not in use?

  Hi. I am almost wrapping up a project of my own and I will have the option to restore the database, so dropping the existing one and then running the SQL script to create the database, tables, stored procedures and so on. My question is, (using .NET 2.0 C#) - what is the best way to resolve the "cannot drop database as it is currently in use" message, or some message of the similar sort Even though I specified "USE MA ...Show All

• BlaineX Transmission Queue problem

  " noWrap width="1%" bgColor=#b71c0c> 1. Yosi   29 Temmuz 12:19     secenekleri goster Gonderen: "Yosi" <yus ... @bizitek.com> - Bu yazar n yazd mesajlar bul Tarih: Fri, 29 Jul 2005 02:19:00 -0700 Konu: Service Broker Cevapla | Yazara Cevap Ver | let | Yazd r | Sadece Mesaj | Asl n goster | Kald r | Kotuye Kullan m Bildir I'm trying the service broker features of SQL Serv ...Show All

• LucLuc Execution of Package failed

  I am trying to design package which would copy all tables and stored procedures from one server to another. It used to be simple task in SQL 2000, there was wizard. However the new wizard does not work... I wrote SSIS package, but when I execute I get the following error: "Can not apply value null to property Login..." Any idea It seems to me that this new SQl2005 is not that simple to use like 2000. 2000 was a great product. I am consider ...Show All

• Big-O How do you do multiple left outer joins???

  I need to do multiple left outer join to return search profiles that could contain NULL in them that could also be foreign keys.  I bolded the three IDs that could be NULL or have a foreign key for a value.  An example with my code would be great I've tried decyphering the many employee and company examples on the web but I haven't figured it out yet.  Right now I only get profiles that have foreign key values and it misses the re ...Show All

• Matt Hohn footer not shown for subreports

  hi, i am showing a subreport from a main reports. i have set header and footer for the subreprt. But it is not shown. Thanks in advance, Vinu You can add a textbox inside the body but out of table or add e rectagle and add all inside it, depend wich type of information you need.. If your reports have the same footer information, then do not create a footer in the subreports. Only c ...Show All