Answer Questions

• funkpuppet Gettint error "product level is insufficient" - did full re-install of SQL 2005 Standard Edition

  Installed SQL Server 2005 Workgroup Edition on a new server for testing. Installed SQL Server 2005 Management Studio on local PC. Created a database with a single table. Trying to run SSIS and export the database to a flat file. Get the error 0xc007470fe: Data Flow Task: The product level is insufficient for component "Destination - dbexport_txt [25]" I then installed SQL Server 2005 Standard Edition on the server as an upgrade of the existing ...Show All

• Phil O MSFT Installing Certificate on SQL Server 2005

  Hi - I'm trying to implement encryption using a 3rd party certificate. I'm following Uncle Bill's documentation on how to install a cert on the server using MMC... I can import the cert into the certificate store just fine. However, when I go to the SQL Server Configuration Manager and bring up the properties window for "Protocols for <Servername>" there are no certs in the dropdown list on the "Certificate" tab. ...Show All

• maguidhir How run SSIS package from MsAccess?

  How run SSIS package from MsAccess Can Access execute command-line commands if not, it can't be done. Why do you want to do this -Jamie No, command-line not help me. I need to add parameters to the package... Executing a package from the command-line using dtexec is the ONLY way you can pass parameters to the package. I'm confused as to: a) Why you thi ...Show All

• Sharmila Vijayan How to expire cached reports?

  How can you expire the cache for a given report Expring on a schedule does not work for me as I do not know in advance when I want this to happen. I feel that scheduled jobs themselves should not be used directly, and I cannot find any API to interact with them. Any ideas I want to do this programatically, via the WS for example. You can use the SOAP API to call FlushCache() for a specific report when you need the cache invalidated. h ...Show All

• dlcrawford metadata driven SSIS package--table variable

  Is there anyone know if a simple SSIS package (moving data from source table to target table) or task can be called repeatedly using a variable that obtains value once a time from a metadata table containing only table names. Basically, I would like to pass in a table variable to the SSIS package or task to start the ETL for different tables. Thanks a lot! Oliver   Oliver77 wrot ...Show All

• bryhhh Looking for the definitive answer: Microsoft SQL Server 2005 Express Edition x86 install failed

  I installed, uninstalled, deleted, editted my registry etc and I finally goto to this error while trying to install VS2005 (released) on a Windows 2000 PC (that had Beta2 and RC1 installed & uninstalled): [11/17/05,16:46:51] Microsoft SQL Server 2005 Express Edition x86: [2] Component Microsoft SQL Server 2005 Express Edition x86 returned an unexpected value. [11/17/05,16:46:51] Microsoft SQL Server 2005 Express Edition x86: [2] Return from ...Show All

• percent20net System.OutOfMemoryException in Reporting Services 2005

  All, I keep seeing "System.OutOfMemoryException" in my production website/reportserver (in the reportviewer). I'm running a report that can return a variable number of records. The test I am running has 16000 records. When I run the report on a test website/reportserver pointing to a test database the report works perfectly. When I run the report on the production website/reportserver pointing at a production database it bom ...Show All

• sko Subquery returned more than 1 value error

  Hi group I get the above error in my SP when the tblHolidayDates has more than one record. Here is my SP: begin if datediff(day,getdate()-10 ,(Select HolidayDate from tblHolidayDates))= 3 AND DATEPART(dw,(select holidaydate from tblHolidayDates)) = 1 -- Monday Date SELECT su.SuspensionID, su.ConsentNo, si.SiteID, si.NameNo + ' ' + si.Address1 AS SiteAddress, si.SiteDesc, si.SuspensionStart, si.SuspensionEnd, si.Address1, si.BaysAttached, ...Show All

• BrentRogers Data Mining Query returns ADOMDDataReader

  Hello, I created a Market Basket Data Mining Model with Association Rules, which I want to query and show in a Report. Everything works fine, when I preview the result in the Reporting Services Data tab I see some sort of table which I can expand and then see the related products. Unfortunately this result seems to be an ADOMD Datareader which I cannot place in a table, matrix or textfield. If anyone knows how I can make this Informatio ...Show All

• Lee Barker SELECT in a table takes FOREVER

  SQL Server 2000, QA Database: A table called Telephone_Directory with just 4.000 records. SELECT * FROM Telephone_Directory is taking forever. If I stop the select after 1 second I see 162 rows. If I stop the select after 1 minute I see again 162 rows. Why this could be happening The same querie on Production Database is taking 6 seconds to retrieve the 4.000 records. Thank you for your answer. I thought the sa ...Show All

• bohan Is replication without network connection but file-based possible?

  Hello, I've been looking around in several SQL-Forums and in SQL Books Online but haven't found clear suggestions how to tackle my problem: Our company has to fill a database with documentation for our contractor. Our subcontractors have to supply information from their branch/craft into this database, too. Replication (without determining a type at this time) would do fine for data-exchange between us and our subcontractors. But for working in ...Show All

• Liu Xiong Creating a dummy dimension level for storing calculated members

  [SQL Server 2000 question] I have a dimension that has one hierarchical (grouping) level (call it "Group 1") and a leaf level.  I want to create a member in the grouping level that will only be used to store calculated members.  The obvious way I found to do this was to create a dummy record in the underlying table with both the group 1 attribute and the leaf attribute having the same value.  I could th ...Show All

• Jason Whitehurst SQL MOBILE ERROR 28037

  I'm facing a problem when sychronization data between pocket PC and database server. It shows error "A request to send data to the computer running IIS has failed". How can I fix I'm using Pocket PC 2003 emulator. I can access replication internet url by pocket IE. I also open port for HTTP and HTTPS both. Best Regards, May be this can help you! http://search.msn.com/results.aspx q=SQL+Server ...Show All

• KonstantinosL Restore Analysis Backup to new DAtabase Name

  I have backed up an AS database. Now I want to restore it to a new name so I have two copies to play with.  How do I do this Thanks, Chris That doesn't work.  The database name is not based on the backup file name.  It is encoded in the backup. Hi, I'm not sure how to copy a SSAS database by backup/restore. However what about - copy the VS project - deploy the project with a different name I guess that might be even ...Show All

• Dennis Quintela Calling Com dll object from SQL Server

  Hello All, I wonder how this can be accomplished. We have created a class lib wrapper that imports the com dll. Upon placing the assembly in sql 2005, both the wrapper Dll and the com dll (probably a converted version) gets placed inside the sql 2005 assembly store. Next a CLR sp references the 2 assemblies above, but within the call to the CLR sp things fail with exception: System.UriFormatException: Invalid URI : The URI is empty T ...Show All