Answer Questions

• Trisk2 Execute parameterized select statement from data flow

  I have following requirement. From OLE-DB source I am getting IDS. Then lookup with some master data. Now I have only matching IDs. Now I need find some filed(say Frequency from some table for each above id). I already write stored procedure for same where I am passing ID as parameter.Which is working fine when I run it SQL server management studio. Query is sort of Select field1,fiel2... from table 1 where id = @id @id is each ID from lookup Now I want to call this stored procedure in Data flow. I tried it using OLE DB command but it did not return output of stored procudre. I am getting output same what ever I am passing input. Is there way to do this In short my requirement is execute parametrized select stateme ...Show All

• Jonas.S Changing default parameters cause postback\refresh

  I think it has been discussed previously that having default parameter values based on expressions, e.g. a default parameter value of =Split("Bug",",") in multiple parameters will cause a postbacl whenever a user selects different values from the list. Is this by design Its a bit of an annoying thing. The refresh\postback doesnt happen if you have basic defaults like ="All" but only when an expression of some sort is used in more than 1 parameter. Does RS think they are linked or something, why does it need to psotback\refresh Anyone know of a solution to this Hi John, I have a similar problem in that I am trying to achieve casca ...Show All

• Greg Allen SQL 2000 is corrupt

  My installation of SQL 2000 is corrupt. THis occured after I uninsalled MS Business Contact Manager and then uninstalled SQL Server (Following ther advice of MS). I then accidemtly installed an incorrect language version of the software (Dutch) instead of English. Uninstalled via the Add / Remover Programes tools and tried to reinstall the english version. I have read artical 830477 which explains how to correct the situation however I donot know where to find the original setup files. (SQLrun01.msi) Are they hidden somewhere on the MSOffice 2003 CD or on the Business Contact Manager CD If so where. Also I am unable to remove the Business Contact Manager Software because the SQL installation is currupt. Any advice as to how to ...Show All

• boston123 is there a way to attach remote files when send email with database mail? thanks

  . Could you explain this in more details HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- it doesn't look like it is a security issue, my sql is on a server named sql8, so I send email like this execute msdb..sp_send_dbmail @recipients='wyx1999@hotmail.com',@subject='subject',@body='body', @file_attachments='c:\header.gif' it works fine, but if I send execute msdb..sp_send_dbmail @recipients='wyx1999@hotmail.com',@subject='subject',@body='body', @file_attachments='\\sql8\header.gif' it gives me error Msg 22051, Level 16, State 1, Line 0 Attachment file \\sql8\header.gif is invalid. that is why I thought remote file doesn't work, ...Show All

• aoky How to edit someone else's report definition?

  I need to be able to share report definitions with other people in my group, so we can all edit and makes changes to each report definition if the need arises. When I tried to use a shared folder the other person could not access my report def, so evidently there is security applied. What's the correct method to do this Please point me at the documentation if it's listed somewhere - even an MSPress book would be fine. This is for both SQLRS2000 and 2005. thanks Peter OK - further forward progress, however the data source apparently does not bring over the credentials so I assume we'll have to enter them again manually. thanks!! Try this. You will each have a ...Show All

• moveit Access2000 Database(table) replicated to SQL 2000/2003 server

  I'm trying to replicate a table(s) in access 2000 to MS SQL server 2000/2005 programatically on a timed instance and then have these tables merged in SQL to create one table. Any guidance appreciated. Thank you, This isn't possible to do from MS SQL Server side using built-in Replication, Oracle is the only non-SQL Server database that can be published (in SQL Server 2005), you may want to post your question in an Access forum. ...Show All

• Aamir Iqbal error on Mining Accuracy Tab

  Hi All I have installed SP2 for SQL server 2005, i just want to try datamining like in the tutorial, i found error if i click "Mining Accuracy Chart" for comparing model with error " TITLE: Microsoft Visual Studio An error prevented the view from loading. ADDITIONAL INFORMATION: Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)) (System.Windows.Forms) " any body can help. thanks Hello, Do you have visual studio installed in the system Did your .NET framework installation was successfull Check in your system if you have System.Windows.Forms.dll. If your Microsoft .NET framework / Microsoft Visual Studio installation is not successful you might hit this ...Show All

• fj64 Stored Procedure - How To?

  I have just started with stored procedure and created the code below in SQL 2005 Manageent Express but when i go to the Stored Procedure folder I can't see it, why SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Author,,Name> -- Create date: <Create Date,,> -- Description: <Description,,> -- ============================================= ALTER PROCEDURE [dbo] . [add_new_person] @id_type varchar ( 50 ), @id_number varchar ( 50 ), @date_of_birth datetime , @person_name varchar ( 50 ), @nationality varchar ( 50 ), @gender varchar ( 50 ), @marital_status varchar ( 50 ), @blood_gr ...Show All

• laue How to: join 1 table to 2 columns in another table?

  I have two tables: Orders, with OrderID as primary key, a code for the client, and a code for the place of delivery/receipant. Both the client and place of delivery should be linked to the table: Relations, where each relation has it's own PrimaryID which is a auto-numbered ID. Now I want to substract my orders, with both the clientcode, and the place of delivery code linked to the relations table, so that for both the name and adress is shown. I can link one of them by: InnerJoin On Orders.ClientID = Relations.ClientID, but it's not possible to also link to the ReceipantsID. Is there a way to solve this Hi , next time please provide some DDL , assuming on your explanations ...Show All

• AlexBB AMO Question - Distinct members in Cube

  Hi, How to filter members in a dimension. To meet a requirement, I made a table as a Fact and a Dimension. In the said table, I have a column which is varchar and contains unique values always. They can be said as 'A' or 'B' or 'C'. For all records in the said table, any of these three values can be present. But they are not from any lookup table but come from a third party system. Using the AMO object, I am listing all the values are members. But the problem I am facing is, I am getting all values as members. As per my requirement, I must list only distinct of them I am setting the DimensionAttribute object's Usage property to Key, OrderBy to OrderBy.Name and Type to Regular. What other property need to be set to list ...Show All

• ZhenYuan How to handle null value?

  My way: add column (boolean) to speicify whether is null or not in drived column component, i feel that's a little difficult any better ideas thanks I guess we need to understand why that's so difficult before we assess the alternatives. I'm still not clear on what you're trying to achieve and what the problem is with adding a new boolean column to your derived column transformation. that's what i did any better ways well,what i first did is 1.add a column(boolean) to specify whether is null or not in derived column component 2.insert into table followed the boolean value in destination script component Now i process this like th ...Show All

• C&amp;#233;sar Andrade How to INSERT Decimal value into a .DBF file using VS2005

  Hi, I use this code to connect into my Database: db2 = New ADODB.Connection dbConn = "Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=C:\PATH\; Exclusive=NO;Collate=Machine;NULL=YES;DELETED=NO; BACKGROUNDFETCH=YES;" db2.Open(dbConn)   inside my app, I use this command to INSERT into .DBF named testInsert.DBF, the testInsert.dbf has the feilds of: Name( string format) & Amount(Decimal format)   Dim Conn as String Conn="INSERT INTO testInsert.DBF VALUES ('shippers06','625.06')" rs.Open(Conn,db2) In this Coding, the VS2005 returms me an error of "DATA TYPE mismatch" I try to Convert the value 625.06 to Decimal but it just don't work... Please HELP a noobie ...Show All

• Sabrecat Using Flat File Connection Manager Editor with delimited format

  Hello everyone: I am new with SSIS and I have a problem that I don’t know solving it. I have a simple package with a delimited flat file source which is loaded into a table in a SQL Server database. Below is the import format: - Row delimiter: carriage return and line feed {CR/LF} - Column delimiter: Comma {,} - Text qualifier: “ In the source file, the data looks like this: “string1 ”, 34, “”, , ,” string2 “text1” string2” , “ “, This package with DTS works, but now with SSIS does not, when I see the “previous rows” in the Flat File Connection Manager Editor, the last column has incorrect information and when I create a new file without spaces and without twice “” in the sa ...Show All

• richardpushpa_v Stored Procedure Recompiles

  Books online says that a recompile occurs : the first time a stored procedure is run after Microsoft SQL Server 2005 is restarted and if an underlying table used by the stored procedure changes. Are these the only times the stored procedures are automatically recompiled There can be several reasons for recompiles including statistics changes to your table(s), use of certain SET operators in your procedure (I.E. SET CONCAT NULL YEILDS NULL, SET ARITHABORT). Check out the following KB article for more information on recompiles: http://support.microsoft.com/kb/243586/en-us Edited to add: Although the above ariticle is specific to SQL Server 2000, most of the issues in that article also appl ...Show All

• Cataa How to define a user variable on Execute Sql Task??

  Hi everyone, How to define a Input variable in a Execute Sql Task I've defined a User::Inicio variable which contains 4 as value. In Parameter Mappins it has been defined. Then, I've gone to General->Sql Statement and allocated the following SQL Statement: UPDATE CARGAPROCESOS SET FECHAULTIMACARGA = [Inicio] or UPDATE CARGAPROCESOS SET FECHAULTIMACARGA = [User::Inicio] Anyway, I'm stuck, both did not work Thanks in advance for your comments Rafael is telling you to set an Expression for the SQLStatementSource property and not set the property value directly. Looks like you set the SQLStatementSource directly to "UPDATE CARGAPROCESOS SET FECHAULTIMACARGA = " + @[User::Inicio]. To ...Show All