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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 DTS error for copy data
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Zath
Constraint Violating Yak Guru

USA
298 Posts

Posted - 02/05/2007 :  09:12:05  Show Profile  Visit Zath's Homepage  Reply with Quote
Getting an error:

Error at Destination for Row number 358. Errors encountered so far in this task: 1. Unspecified error.

My question is row 358. I have an ID column but the numbers are not in order and some are missing, like 3 is missing, doesn't exist, never has.

So, row 358 would not be my ID number but the actual row 358?

And if so, how to pull it up using a sql?

Thanks,

Zath

Zath
Constraint Violating Yak Guru

USA
298 Posts

Posted - 02/05/2007 :  09:46:28  Show Profile  Visit Zath's Homepage  Reply with Quote
Ok, found the problem and a strange one indeed.

Manually counted the row till I was at 358.

That row had no info on some columns, it was an empty string.
Did not have the <NULL> value in it, so, I put something there and it transfered ok.

Very strange...

Quick question, how to input the <NULL> back for those columns?

I forget the keyboard shortcut for it.

I can do it using a sql of course update mytble set myfld = null, but there is a keyboard shortcut to do this while having the table open.

Thanks,

Zath
Go to Top of Page

PurpleSun
Yak Posting Veteran

USA
50 Posts

Posted - 02/05/2007 :  11:01:18  Show Profile  Reply with Quote
Keyboard shortcut is <CTRL> + 0
quote:
Originally posted by Zath

Ok, found the problem and a strange one indeed.

Manually counted the row till I was at 358.

That row had no info on some columns, it was an empty string.
Did not have the <NULL> value in it, so, I put something there and it transfered ok.

Very strange...

Quick question, how to input the <NULL> back for those columns?

I forget the keyboard shortcut for it.

I can do it using a sql of course update mytble set myfld = null, but there is a keyboard shortcut to do this while having the table open.

Thanks,

Zath

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000