Answer Questions

• Bug the VB Gamer Error when doing fuzzy lookup

  I am trying to run a SSIS package that contains a fuzzy lookup. I am using a flat file with about 7 million records as the input. The reference table has about 2000 records. The package fails after about 40,000 records with the following information: ------------------------ Warning: 0x8007000E at Data Flow Task, Fuzzy Lookup [228]: Not enough storage is available to complete this operation. Warning: 0x800470E9 at Data Flow Task, DTS.Pipel ...Show All

• JLucak How to execute ssis package from stored procedure

  how to excute ssis package from stored procedure and get the parameters back from ssis into the stored procedure. Darren, I'd very much like to use CLR for the reasons you give. Do you have a code example using CLR in a stored procedure to run an SISS package where parameters are passed in and out I have a DTS package on my SQL 2000 box that I want to move to 2005. The current code uses sp_OACreate ' ...Show All

• MARCO RIBEIRO Report Builder "Report Execution Error"

  I get this error with Report Builder "Report Execution Error"  the report might not be valid or the server could not process the data. For security reasons DTD is prohibited in this XML document. To enable DTD processing set the ProhibitDtd property on XmlReaderSettings to false and pass the settings into XmlReader.Create method. What does this error mean I did get my report to run, it seems to work if I add another filter or limit th ...Show All

• Tee40 (SQL Server 2005) Instead of Delete Trigger

  Hi, I simply need a trigger to delete some datasets from a view but have some trouble writing an adequate trigger. Here is my attempt: Use myDB ; Go CREATE TRIGGER IO_Trig_Del_myView ON myView INSTEAD OF Delete AS BEGIN SET NOCOUNT ON -- Check for dataset, if present delete. IF (EXISTS ( SELECT Z . [myPk] FROM myTable t , deleted WHERE t . [myPk] = deleted . [myPk] )) Delete From myTable Where myTab ...Show All

• Daniel Pravat sql 2000 table format

  There is a table with the following fields: id,year,UserCode,A2,A3,B2,B3 Usercode is a varchar fields whereas the other fields are integrers. Let's say this is what the table contains at present: id year Usercode A2 A3 B2 B3 1 2005 2BM 12 7 9 11 2 2002 BB1 87 98 4 32 3 1999 3NS 45 32 88 12 ... The question is, how can I produce something like the following table using the above table: The idea is to show the final table (at the very ...Show All

• davidMcKenzie Wired to Wireless Connection Issues

  When using both SQL Server Management Studio and my own application to connect to my SQL Server, I can connect and retreive data without issue when on a wired connection. As soon as I unplug the wire and switch to the wireless connection I have problems. I can connect to the SQL Server without issue (in MGMT Studio and through my code). I can even return small tables, however when the table is larger (about 175 rows) I get the following error: ...Show All

• 10wattmindtrip dynamic sql query syntax

  Hi friends I need ur help with syntax of following dynamic sql.actually it is simple version of what am doing but i know for sure this line actually causing the error. DECLARE @p_taskentrydtfilter nvarchar(50),@taskentrydttag nvarchar(100) declare @p_taskentrydt DATETIME set @p_taskentrydtfilter= '>=' set @p_taskentrydt = '20050609' select @taskentrydttag=case when (@p_taskentrydt='' OR @p_taskentrydt is null) then '' else ' and task.entrydt ...Show All

• Sam Spencer VB.net 2005 and SQL

  Hello, I'm relitively new to the VS.net 2005 platform and need to create an SQL database for my current project to work properly, but I keep being told that I can't access the SQL Server 2005 Express to create an database. Has anyone else had this problem, and how can I get around this Thanks N. Rawe No, this hasen't worked and it is the same error i am experiancing with MySQL as an alternative. For now i shall just use access to ...Show All

• Studix 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. This a QA Database, I check the sp_who2 com ...Show All

• devgrp What is necessary to create SDF-Files on desktop legally?

  I want to write a PC application that prepares a SQL Server Mobile Files (.SDF) and sends it to a PocketPC. I get this error message: "SQL Mobile usage is restricted on this platform. To use SQL Mobile, you must install SQL Server 2005, Visual Studio 2005, or the Tablet PC SKU" If I install "SQL Server 2005 Express" the error message disappears and everything works fine. Question: Is it allowed to create SDF-Files if "SQL Server 2005 Express" ...Show All

• Stephen L Getting DataType of a IDTSCustomProperty90 object

  Hi,   I need to get the data type of a IDTSCustomProperty90 property. I can get a control flow DtsProperty data type by simply using the Type property (which returns a TypeCode) on the DtsProperty object. However, not able to find a similar property/method on a IDTSCustomProperty90. Thanks, -Suri The custom property gets its data type from the data type of the value that is assigned to it, and (as yo ...Show All

• Infinite Dimentia SQL Server 2005 incorrectly claims I don't meet minimum service pack level requirements?

  This doesn't make any sense. I am trying to install SQL Server 2005 on SBS 2003 with Service Pack 1. According to Windows Update, there is nothing left for me to install. However, I am getting this error (while installing SQL Server Express and the Developer Edition): "Your operating system does not meet Service Pack level requirements for this SQL Server release. Install the Service Pack from the Microsoft Download Center at http://go.m ...Show All

• LavP Writing data from multiple tables to a single flat file

  I have a package that contains three database tables (Header, detail and trailer record) each table is connected via a OLE DB source in SSIS. Each table varies in the amount of colums it holds and niether of the tables have the same field names. I need to transfer all data, from each table, in order, to a flat file destination. I have created a flat file connector containing all the necessary fields that need to be transferred from the abo ...Show All

• Nickthegreek Exception of type 'System.OutOfMemoryException' was thrown. (Microsoft.SqlServer.SmoEnum)

  I just received this message: Exception of type 'System.OutOfMemoryException' was thrown. (Microsoft.SqlServer.SmoEnum) I am completely dead in the water. Cannot connect to SSAS 2005. HELP! I forgot to mention, please double check and remove sensitive meta-data in the AS2000 database and the migration script. Especially verify the connection strings for data sources (for passwords - just change the connection strings in the scr ...Show All

• smurfgbr DSV and Cube do not match - generates Key Errors

  Hi All, This is strange behaviour, hopefully I can resolve it without rebuilding the cube and all the dimensions from scratch. I have a cube with a fact table, and a number of dimensions, including an EventType and Event Date.  (Event Type is "Sale", "Return", etc.etc, Event Date is the date it occurred) When I created the DSV for this I accidently joined the fact table EventTypeID field to the EventTimeID on the Event Date di ...Show All