Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Data Corruption Issues
 Curruption of SQL + error

Author  Topic 

KiriatMitskin
Starting Member

1 Post

Posted - 2014-08-31 : 08:13:02
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.

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-08-31 : 08:26:21
You haven't posted enough information for anyone to help you. try posting:

1. the dts(x) file
2. the error log
3. a full description of the purpose of the package, including all inputs and outputs and business logic.
Go to Top of Page

MollyHowdy
Starting Member

1 Post

Posted - 2014-08-31 : 12:53:18
Firstly you need to use built-in function of Restore a Database Backup through SQL Server Management Studio. It will help you in case of availability a database backup copy.
If database backup is absent or corrupted, you may take into use For more info click here http://goo.gl/M0fotU
http://social.msdn.microsoft.com/Forums/en-US/0852c5a5-0a3f-45b9-b43e-12364f570c48/sql-database-recovery?forum=sql14tools
Either given tool helps if your sql database is huge, software is able to repair sql databases in the amount ofup to 16TB.
Go to Top of Page

Lincolnburrows
Yak Posting Veteran

52 Posts

Posted - 2014-09-02 : 05:07:02
I think you are gettting wrong data at the row 1574. So if you want to check what is wrong. In the Transformation properties go to advanced tab there change the Max row count from 0 to 1000 or more then give the exception file name. Run the DTS package then check the exception file then you can see the what row giving the wrong data.
Check all this stuff...
Go to Top of Page
   

- Advertisement -