Answer Questions

• kangalert A who dunnit mystery -- which column(s) is invalid?

  I'm importing several hundred thousand lines of text data with multiple columns in each record. While SSIS can redirect a line with an error to an error output is there any way it can "tell me" which column or columns caused the error on that row (After al,l it certainly recognized that a column was bad, so I'm hoping it can just tell me what it found.) TIA, Barkingdog Yeah, the error flow contains a column telling you which column the error occurred in. I don't have a SSIS instance handy so can't tell you what it puts in there but I think its the lineage ID of the column. -Jamie Yes it is the lineage ID of the column. Lineage ID is not very user fr ...Show All

• nextpaco Checking Out Data to Client Users

  I'm trying to resolve an issue that I've run into in my current system. I have about 10 clients accessing a SQL Server several times per minute (every 10-20 seconds). To have an individual find the next record, I follow the following process: 1. Select the value of the next record in the database to be checked out. 2. Update the record to show that it is checked out to the user. 3. Select the data in the record to display to the user. 3. Update the record to show any changes and to check the record back in after the user edits it. My issue is that clients can execute at the same time. Right now, with just SQL statements, two clients can get the same value in step #1. That makes them select the same record for editing. Can I use T- ...Show All

• Kestutis Using openrowset (bulk...) with Variable in Filespec

  Hello, to accelerate loading xml data from many files into a table using openrowset (bulk...) I want to use a variable in the file specification and increment it within a loop similar to this: declare @datnam varchar(100); DECLARE @MyCounter int; SET @MyCounter = 1; set @datnam = 'c:\XML_Daten\POS_LOG_200608_'+ltrim(str(@MyCounter))+'.xml'; INSERT INTO GK_TO_KFH_ADAPTER_XML_NS (LOC_ID, MSG_CONTENT) SELECT @MyCounter, MSG_CONTENT FROM ( SELECT * FROM OPENROWSET (BULK @datnam, SINGLE_CLOB) AS MSG_CONTENT) AS R(MSG_CONTENT) But I got the following error: Msg 102, Level 15, State 1, Line 8 Incorrect syntax near '@datnam'. Is there a way to this in that manner Or is the bcp utility an alternative Regards Peter ...Show All

• ihd4me How to relate InstanceID of RunningPackage object to logging?

  Iterating through Running packages as in this code from MSDN: RunningPackages pkgs = app.GetRunningPackages("yourserver"); // Enumerate through each package in the collection and display some data. foreach (RunningPackage package in pkgs)     {         Console.WriteLine("InstanceID: "+package.InstanceID);         Console.WriteLine("PackageDescription: "+package.PackageDescription);         Console.WriteLine("PackageID: "+package.PackageID);         Console.WriteLine("PackageName: "+package.PackageName);         Console.WriteLine("UserName: "+package ...Show All

• julianenrique Update Query help needed!

  I have a report that takes one MD (my Source Doctor) and his/her Fee Schedule and it should copy and update the fee schedule to my other Doctor (my destination Doctor). The report currently (as listed below) only inserts doesn't update on the feeschedule that is modified. I need to somehow update the existing feeschedule... I can do that by itself... Update dffeeschedule set expiration = 'xx-xx-xxxx' where dffeescheduleid = yy and where expiration is null That should work except that I don't know how to separate out the two! Report Query: CODE declare @dest varchar(8000) declare @src varchar(255) declare @fs varchar(255) select @src=(select listname from doctorfacility where doctorfacilityid=7) set @dest='' select @fs=(select fee ...Show All

• Rajesh.Y Trigger for LOGIN

  How to create a trigger for a login with username and password. If unauthorized user tries to login, his username and password should be stored into intruder table. so ur not talkin abt db login..but ur application login.... u cant use a trigger in that case..(to log a failed login), as trigger can be on insert update or delete operation on a table...and u'll just be doin a select on the login table...so write an insert (into ur failed login table) when the login fails What is the version of SQL Server that you are using In older versions of SQL Server, there is no concept of a trigger for login. SQL Server 2005 SP2 adds the capability to define login triggers. However, you still cannot obtain the username and password. SQ ...Show All

• Matt Lin RS2005 Non-Queried Default Value Not Set after Deploying to Report Server

  Hi all, I'm not sure if this is a bug in Reporting Services 2005 but whenever I use a string as a non-queried default value for a multi-value param, it will not be set after I deploy the report to Report Server. It works fine in the preview tab of Report Designer though. I haven't tried it on single valued params but I'm guessing same applies. Anyway, if you guys encounter this too, the way to solve it is quite simple. Delete your previous report from the server and deploy it again. The default value will now be set properly. Hope this helps! Thanks also to another post from "smhontz" who encountered this in RS2000: Cheers, INK ...Show All

• medosoft07 How to Add an event to CRI controls

  Hi all, I am trying to develop a CustomReportItem similar to Matrix control. Is it possible to add some "OnClick" sort of events to a section of this CRI (As a drilldown button of matrix control allows to expand the respective column). Please help me if there can be any solution. Hi Robert, Thanks for ur response I am asking it for runtime. How can I encode the toggle state in parameter values and how will it help to solve my problem Please explain, as I am new to this tool. Are you asking about design time or runtime While the CRI runtime control can generate drillthrough actions based on an image map, currently you cannot fully simulate the matrix group toggle behavior. You would rather need to wor ...Show All

• shahidferoz Interactive Sorting and Calculated Member problem

  I have got a dataset with a report field statusId that is a calculated member. The calculation is based on a VB.NET function returning an integer value. Within a report table the report field statusId is embedded in the detail section (no grouping is used), with an interactive sort on its corresponding header label. Each time the report is rendered, the report table displays the correct information but when I click on the interactive sort button, the report displays zero's in the column the report field statusId is placed. Thank you for your help. ...Show All

• Graham-BLUR-Turner Time Dimension Browsing Very Slow - ProClarity

  Hello, I have a problem when browsing the time dimension (when cube cells have values) I have a standard time dimension with the following levels Year-Quarter-Month-Day. My cube has values for the years 2003 .... until 2006. 2002 Does not have values. When I browse the time dimension for 2002 (the year where cube has no values), I have no problem..but when I browse the dimension for values in the other years.... I wait until 1 minut to make a drill down in the dimension Pane (whitout executing the query). PS: I notice in SQL Server Profiler, that each time I browse the dimension in ProClarity, all my 80 partitions are read in the OLAP Server....without executing the query. Thanks in Advance Joao Campanico ...Show All

• DanMeyers Calling procs on other databases

  Hi. I am currently working between sql server 2000 and 2005. I have written procs in 2005 using some new native features. I wish to remain using 2000 and just call and get return values from procs on 2005 Database. Procs on 2005 DB only access tables on that DB and vice versa. Is there a way to call stored procedures across Servers Cheers, Ewen Look up linked servers in books online. Setting it up is not terribly hard. Then use the four part names where you put the linked server name before the database name: server.database.schema/owner.procedureName Yes. Use the four part object name: server.database.schema.object Of course, security will have to be set up properly. ...Show All

• raayu Bidirectional replication

  Hello, is it possible to implement bidirectional replication with queued updating subscriptions in SQL Server 2000 I am currently testing bidirectional replication on two servers and it works well so far. My concern is how to I update the subscriber or publisher once both servers become disconnected How to I resync thank you for your help, Lars Bidirectinal replication does not support queued updating. But because both servers in bidirectional replication are publishers, if the two servers are disconnected, replication agents will just retry until it can connect to another server. Keep in mind that bidirectional replication does not support conflict detection/handling. Peng ...Show All

• ZHiquan Dimension and Hierachy

  Hi, I am new in AS2005 I builded a Dimension "ShipToState" with Hierarchy "ShipToState", "ShipToCity", "ShipToZip"... When I browse my cube from Excel I see "ShipToState", "ShipToCity", "ShipToZip"... as 3 different dimensions and a new dimension named "Hierachy".....I think I am doing some mistakes..... Someone can help Thx Mcrisf Each attribute has a property called AttributeHierarchyVisible which you can view and set in the property panel. If you set this property to False for ShiptToCity and ShipToZip, then those will not show up in Excel as Hierarchies but they will still be available in the user define ...Show All

• jwalker343 SQL Server 2005 on A/A cluster

  We have SQL Server 2005 on windows 2003 server +SP1. In the application log I noticed the following errors during . Event Type: Error Event Source: MSSQL$SQL Event Category: (3) Event ID: 19019 Date: 2/13/2007 Time: 6:36:53 AM User: N/A Computer:xxx Description: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure Event Type: Error Event Source: MSSQL$SQL Event Category: (3) Event ID: 19019 Date: 2/13/2007 Time: 6:36:53 AM User: N/A Computer: XXX Description: [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed ...so got the below information from the cluster log: 000009fc.00000d68::2007/02/13-12:36:53.210 ERR SQL Server <SQL Server ( ...Show All

• Sunkyu Hwang SQL2005 database mailer problem

  Hi there, Got a 2005 SP1 SQL box, with database mailer giving problems. In the sysmail_event_log is has 1) Exception Information =================== Exception Type: System.NullReferenceException Message: Object reference not set to an instance of an object. Data: System.Collections.ListDictionaryInternal TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32) HelpLink: NULL Source: DatabaseMailEngine StackTrace Information =================== at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID) at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.SessionManager.GetAccount(Int32 accountID) at Microsoft.SqlServer.Management.SqlIMai ...Show All