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 |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2006-02-28 : 06:42:09
|
| I am trying to import a sql table from one sql database to another using DTS. I am getting an error and when I dblclick on the row it says'Error at destination row 44324 .Errors so far encountered in this task 1. Unspecified error'How do I find and list row 44324 ? Or is there something else I should do/checkTIA |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-02-28 : 08:13:35
|
| If u don't want to schedule the task and if its not doing that often, u can use a query to do the same task.Run a query in SQL AnalyzerInsert into urserver1.urdb1.dbo.urDestinationTable (<fields list seperated by commas>)Select <fields list seperated by commas> from urserver2.urdb2.dbo.urSourceTable |
 |
|
|
|
|
|
Find a certain row in a table