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.
| 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 workinggreat 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 THETASK. 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) file2. the error log3. a full description of the purpose of the package, including all inputs and outputs and business logic. |
 |
|
|
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/M0fotUhttp://social.msdn.microsoft.com/Forums/en-US/0852c5a5-0a3f-45b9-b43e-12364f570c48/sql-database-recovery?forum=sql14toolsEither given tool helps if your sql database is huge, software is able to repair sql databases in the amount ofup to 16TB. |
|
|
|
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... |
|
|
|
|
|
|
Curruption of SQL + error