473,544 Members | 713 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to repair sql table - Error in DTS

Mac
I have schedule DTS to import every day few tables. It had been working
great and had no problem. All of a sudden I started getting this error.

ERROR AT DESTINATION FOR ROW NUMBER 100. ERROR ENCOUNTERED SO FAR IN THE
TASK. 1 UNIDENTIFIED ERROR.

Thanks.

Jul 23 '05 #1
2 5439
You will need to debug it. It looks to me data related. Maybe some type
of data conversion is now failing?
If you open the DTS package and manually execute it, does SQL
give you a different error message?
"Mac" <ma*@hotmail.co m> wrote in message
news:Bw%oe.7719 $nr3.2323@trndd c02...
I have schedule DTS to import every day few tables. It had been working
great and had no problem. All of a sudden I started getting this error.

ERROR AT DESTINATION FOR ROW NUMBER 100. ERROR ENCOUNTERED SO FAR IN THE
TASK. 1 UNIDENTIFIED ERROR.

Thanks.


Jul 23 '05 #2
Here's one possible reason:

http://support.microsoft.com/?kbid=890841

If that doesn't apply, then perhaps you can give some more information
- what are the source and destination of the data, are there any
column-level transformations , have you looked at row 100 of the source
data to see if anything is in a different format from row 99 etc. You
might also post to microsoft.publi c.sqlserver.dts to see if someone has
a better suggestion.

Simon

Jul 23 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
15249
by: Jean-Luc Fontaine | last post by:
Here is what I did: - I had a perfectly working compressed table: ccc in database ddd - uncompressed it: # myisamchk -u history200310 - recovering (with sort) MyISAM-table 'ccc' Data records: 13786290 - Fixing index 1 - then tried to access it
0
5215
by: Matt | last post by:
Hi everyone, I'm using the command "mysqlcheck --all-databases --auto-repair --silent" and I see these warnings and errors (listed below) on a daily occurrence. What could cause these indexes to be out of order? Another thing I don't understand is why an increase in the number rows constitutes a warning? Hoping to here from MySQL users...
3
5559
by: Paolo | last post by:
Hi, I am trying to compact and repair my database, however every time I try it comes up a message saying: Table: "TempMSysAccessObject already exists", whenever I try to look for this table I cannot find it anywhere... Any clues... Already went into the help file and nothing... Also try to copy my database and the same message comes up
6
3056
by: GaryDave | last post by:
My school registration database has not been quite right after a recent compact and repair (done while I was away). Though most of the many forms and subforms are working normally, one form in particular will no longer allow new entries into the subform - the recordset of the underlying query is no longer updatable. The subform in question...
3
1408
by: John | last post by:
Tonight I had a corrupt database which Access was able to repair after I made my backup. The database seems to be working well again. How certain can I be that the database is repaired well and doesn't have any hidden errors still inside. Should I take some other precautions? Should I rebuild the app beforehand by importing the tables, reports...
2
2775
by: Ron | last post by:
Hi All, Using WinXP pro/Access 2000. I have a database that's been used for about 5 months. Transferred lots of data from a dos based program, then the users have been using it for that 5 months. About 180000 records in one of the main files (maybe 25000 new since the dos conversion). Been having some speed issues crop up along the way...
1
1352
by: ramdil | last post by:
Hi all.I am facing one error using the repair database tool I have a access database created on 97 version.when i tried to repair the database using the utilities tools,its giving me a message "the changes you requested to the table were not successfull because they would create duplicate values in the index ,primary key, or...
3
2195
by: Bizmark | last post by:
Access2003, Windows XP Pro OEM user OS, Windows Sever 2000 server OS. Not-so-recently I inherited 3 Access DB's from another company merging with our own. Our own system works off of SQL server, but mainting these databases is critical to keeping the business running. 1 database in particular has been causing problems. Along the course we...
9
3304
by: Timmy! | last post by:
A2003 on Win XP Pro. A number of very stable apps I have are lately sometimes crashes when I do a compact & repair, especially when I hold the shift key to do so. When this starts happening, I usually turn off or restart my computer. Sometimes this stops the crashing, sometimes it doesn't. I'm really not sure why this is happening, I've...
3
2654
by: Simon van Beek | last post by:
Dear reader, It is possible to repair a lost linked table but in case the backend database (mdb) is in use the process to repair the linked table process is not working. Then the message pups up "mdb is in use".
0
7439
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7633
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7395
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7722
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5935
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3433
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
1
1851
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
997
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
679
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.