Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 14-07-2009
Member
 
Join Date: Jul 2009
Posts: 2
SQL Sever DTS Error

I am recently learning SQL Sever & is facing a problem with it... I have received a message saying "The number of failing rows exceeds the maximum specified". How do i increase the failing of the maximum specified for row???
Reply With Quote
  #2  
Old 14-07-2009
Member
 
Join Date: Feb 2008
Posts: 1,848
Re: SQL Sever DTS Error

CASE :
A cause of this error can be that a leap year is set up for the wrong year. Check all the February period end dates and ensure that all leap years are set up for the correct years.


Solution :
If you find a leap year set up for the wrong year you must correct this in the General Ledger as this will cause a Null value in our tables. Once this is done re-run the load.
Reply With Quote
  #3  
Old 14-07-2009
Member
 
Join Date: Oct 2005
Posts: 2,389
Re: SQL Sever DTS Error

There is a simple solution for it. You need to select properties of Transform Data Task by right clicking on it, then select the Options tab. Now change the Max Error Count in the dialog box.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "SQL Sever DTS Error"
Thread Thread Starter Forum Replies Last Post
Unable to launch the dedicated sever tool in Duke Nukem Forever Angee Video Games 5 16-06-2011 10:36 AM
Not able to ping telnet from different client sever Happy46 Networking & Security 4 01-04-2010 11:37 AM
DFS replication between Windows Sever 2003 R2 & SBS VanBC Small Business Server 5 01-07-2009 12:53 PM
Win2003 Sever - Share Permissions - Am I missing something really basic here or what????? sikcapri@gmail.com Windows Server Help 6 19-06-2008 12:15 PM
SBS 2008 Premium - SQL Sever Duncan McC Small Business Server 1 18-06-2008 06:52 PM


All times are GMT +5.5. The time now is 05:34 PM.