Answer Questions

• Caruanas How to write expression for this...

  =Fields!net_comissionable.Value-(Val(ReportItems!textbox14.value) * Val(ReportItems!staffed_hrs.Value))*14.43 this is in a text box that is calculating the referanced box's and I am looking for the expresion that would be if the result of this is <than 0 to return as a 0 if thenn statment or a case statment how does this work. Thanks = iif (<expression>, truepart, falsepart) ...Show All

• stephane - Montpellier SSIS OLE DB Source Error

  I am creating an OLE DB Data Source in an SSIS Data Flow - it is calling a SQL Server 2005 stored procedure, which accepts 3 parameters and returns a result set, but I get the following error: "There is a data source column with no name. All data source columns must have a name." I have have tested the output of this proc a million times, and every column has a name! I am also able to call a different proc in the same way, without error: EXEC pProc @DT = '20060928', @Id = 1015, @Debug = 0 Any ideas what could possibly be causing this error - assuming all of my columns DO have names Thanks : ) mary.oneill wrote: Yes, but I was trying to avoid adding mor ...Show All

• Kishore Gopalan Interesting Note regarding Lookup Transformations

  Basically I noticed that it is better to separate 2 lookups into separate data flow tasks: (Both my lookups retrieved about 25'000 - 50'000 records) Both lookups together: Elapsed time: 00:21:16.172 Lookup 1 flow: Elapsed time: 00:05:42.235 Lookup 2 flow: Elapsed time: 00:03:57.281 Do you know if a custom script task is more efficient than lookups ...Show All

• Mohamed Hussein Kotat Can two Tables have the same primary key ?

  I have been given a project to complete where ... two tables "Flights" and "ScheduledFlights" have a column called "FlightNo" . In both these tables it is mentioned that "FlightNo" is primary key Is this possible i am not talking about foreign key here.... Here is the script that i have created.. create table flights ( FlightNo char(5) constraint FlightNo primary key clustered not null, DepTime char(5) not null, ArrTime char(5) not null, AircraftTypeID char(4) references Aircraft(AircraftTypeID) not null, SectorID Char(5) references Sector(SectorID) not null ) create table ScheduledFlights ( FlightNo char(5) constraint FlightNo2 primary key clustered not null, FlightDate datetime not null, FirstClassSeatsAvailable int not null, B ...Show All

• James_Z Displaying Chinese Character in varchar columns

  I would like to store some data in Chinese Big5 using a varchar column. However, all the data turn in to some garbage characters like Ru￥Uao . I ran into no problem if i use nvarchar but I would like to use varchar because I can only store less than 4000 characters using nvarchar. It works if I paste the characters directly into the SQL Express Client. It only turns into some garbage characters if i use C++ to insert the data. I am using Chinese_Taiwan_Stroke_BIN collation (The chinese won't show if I use the default latin collation) on the column and my computer regional setting for non-unicode application is Traditional Chinese(Taiwan). Any ideas how can I fix this problem I am suspecting there's a problem with my computer setti ...Show All

• Pellaeon XML Source populating CR LF to SQL2005 table

  In my SSIS package I used the Web Service task to populate a SSIS variable with data from an XML feed. Then in the Data Flow I used a XML Source to import that data into a table on my SQL Server. When I looked at the data i noticed that the some of the fields contained CRLF pair. These CRLF pairs are being only populated by xml nodes that contain no data and are self-terminated. Below is a sample of the XML feed that is causing the problems. the DR_M_Initial and DR_Type1 nodes are populating CRLF's to the table. Can anybody give me some insight on this problem. I am performing a workaround using the SQL REPLACE function in an Update statement to strip out ch(10) and ch(13), but this just seems a little cluegy to me. Sample XML ----------- ...Show All

• Kamii47 Updating a Table having a Foreign key constraint

  Hi I am trying to update tables "Table A" & " TableB" with a new value for a particular column1. Now "TableA" contains a foreign key "FK1" defined on it and is referencing another table "Table B" containing the similar column "Column1" Because of this constraint I was not able to update TableA and TableB. My question is 1) If i wanted to go ahead with this update, what are the possible ways 2) If only solution is to drop the constraint. Then How do i know the definition for this particular Foreign key, i mean it may refer some columns in Table B. I wanted to know the complete definition of it so that i can rebuild the constraint after the update. Right now i can se ...Show All

• Sean K. Campbell SPLIT AN ARRAY!

  dear friends, I have a stored procedure that receives a parameter like ' 123#67#1#89#52#' I need to insert each number (123, 67, 1...) in a table... How can I do it using the best performance Thanks!!! Cheers!!! How can I do it ! Could you give me an example thanks PedroCGD wrote: Jean, But I need is to extract each field in a while, and insert each extracted value in one table. The example you gave me is not too long for my case Thanks!! I believe that what Jens posted will work just fine. Did you read the bottom part of that where he actually issues the SQL statement that calls the function In there he passes in the string to be split and it goes from there. The key is in that last SQ ...Show All

• Craig G Remote Access : Where am I wrong ?

  Hi Gurus, I new to SQL Server and unable to connect Reomote Connection. The Environment: Server (Name:SmartDB)= Windows XP SP2 with "Administrator" user Running: SQL Server 2005 Express (Standard)   SQL Browser   SQL Server Configuration:Protocol=TCP/IP=> Enabled   Windows Firewall = OFF Laptop (Name:PSDLaptop)(using as client machine)=Windows XP SP2   with "Administrator" user Network Status: Working Fine ------------------------------- When I am running an application with following CONNECTION STRING: "Data Source=SmartDB\SQLEXPRESS; Database=PSD;Integrated Security=SSPI" the error comes: "An error has occurred while establishing a connection to the server.  When connecting to SQL Serve ...Show All

• tibballs HELP!! i deleted services!

  i have installed vs 2005 and sql server enterprise edition on an xp pro sp2 machine.but i could not connect to the mssqlexpress default database that it came with.in a moment of madness i deleted the mssqlserver services (3 of them).how do i reinstall them i thought uninstalling the products and reinstalling them would help but it did not. please help! cheers yes it it is possible, the only thing is that you do not have access to all the functionality.i have solved the prob by uninstalling and installing the work edition. thanks Sorry to correct you, but installing SQL Server services won’t be available for enterprise edition, only the client tools. Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Santos_123 connecting SQLExpress & Visual C# 2005

  Hi I have started to create a databse using SQL Server Management Studio Express, just a few tables, one with data. I now want to creat a some windows forms to populate the tables. However when I try to use the Add New Data Source wizard, I get an error when I try to create the connection string, but I have managed to connect to a copy of AdventureWorks located in the same parent directory. Error is : Unable to open the physical file "...". Operating system error 32: "32(The process cannot access the file because it is being used by another process.)". An attemp to attach an auto-named database for file ... failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC sh ...Show All

• Astericks Truncate and foreign keys

  Hello all, Simple question. I have two table with a foreign key in between. Then if I want to truncate the tables, of course this is not possible because of foreign key. But with the following code, this should work: EXEC sp_msforeachtable 'ALTER TABLE NOCHECK CONSTRAINT ALL' GO truncate table Table_1 truncate table Table_2 GO EXEC sp_msforeachtable 'ALTER TABLE CHECK CONSTRAINT ALL' GO But I still have the error Msg 4712, Level 16, State 1, Line 2 Cannot truncate table 'Table_2' because it is being referenced by a FOREIGN KEY constraint. What is wrong You will find below the code for the creation of my two tables Thanks for your help CREATE TABLE [dbo] . [T ...Show All

• Mehmet Metin Altuntas OLE DB Destination fails with illegal instruction

  Environment: Server Windows 2003 SP1, VS 2005 I ran into this problem trying to deploy an SSIS package to a development server. I tested by creating a simple SSIS package on the server itself. Two blocks an OLE DB Source block and an OLE DB Destination block. Two tables in the same database, one the source, the other the destination. Connection manager test connection works fine. Package will execute from the IDE (locally on the development server), source block will read the table subcessfully, but when the destination block executes it fails and will stay yellow in the status screen. during the execution SQLDumper.exe is triggered. Analyzing the dump tells me: (2b40.2938): Illegal instruction - code c000001d (first/second chance ...Show All

• wolfman-x Problems Creating Report

  Hi, I have only recently started playing around with Reporting Services (2005), and I am having some problems creating a basic report. What I want to display is a table which shows product names in the first column, sales for a specific period this year in the second column, and sales for the same period last year in the third column. The 'specific period' is determined by specifying a start week and an end week which I have set up as parameters. I have managed to produce the first 2 column with no trouble. However, for the third column I need to subtract 52 weeks from the parameters and use them as new parameter in the third column. Can anyone offer any suggestions Dave Ok, I manag ...Show All

• VSab OpenQuery() to Linked Server hangs, leaving SPID with open tran, then templog.ldf grows without limit.

  Hi, We have a customer that is using SQL Server 2000, and experiencing the following intermittent problem -- occasionally templog.ldf will grow and grow until it fills the entire disk. This is a rare problem, it has happened less than 10 times in the past two years, for a job that runs once a minute. But it has happened on 3 different SQL Servers, (two production servers, and one test server). Our suspicion is that the root cause is an OPENQUERY() to pull data from a linked server (Oracle database on Unix). We have seen that these OPENQUERY() statements occasionally hang and cannot be killed. The OPENQUERY() is used to populate a local table, and when we originally populated permanent tables with OPENQUERY(), then there would be a ...Show All