Attachments aren't allowed.  You could copy and past a few lines from the file if you want.

Knut's solution will work of all the fields are qualified with quotes.

If they aren't, you have a couple of options (that come to my mind - there are probably many...

Have a look at this article as well as its links:

http://www.sqldts.com/default.aspx?205

update MyTable

set MyField = REPLACE(MyField,'"','')

Yes, you could do it in the DTS package as well.  There are multiple ways of accomplishing this.

Sybase is rather similar to MS SQL Server, so most of the cleanup you do in Sybase will only benefit you in your migration.

Here's a link to the online reference manuals:

If you have done the first three, have you pinopinted troublesome query?

BY logging / checking, I mean have you tried setting up the proc with debug / logging info to...

Does the query have any kind of looping?  An unmet ending condition (data differences) would be one of my suspects for what you describe.

Have you looked at locking?

Have you run...

Sounds like you're looking for SQL Server Agent.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_automate_01et.asp

Here's the BOL for Eager Spool:

http://msdn2.microsoft.com/en-us/library/ms190435.aspx

"The Eager Spool operator builds its spool file in an "eager" manner: when the spool's parent operator asks for the first row, the spool...

You've answered your own question: "because the table isn't indexed"

That's your culprit.

Minimally, you can run the select with no locks, assuming you don't care about a "dirty" read.

SET TRANSACTION ISOLATION...

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_5ell.asp

CP1 specifies code page 1252, for all other code pages the complete code page number is specified.

I'm a big fan of Diagnostic Manager (put out by Idera these days I believe...).

You are correct.  There are security considerations with TRUNCATE:

"The minimum permission required is ALTER on table_name. TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server...

How are you "clearing" the table?  If you use TRUNCATE, the identity will re-set to your original seed value.

You may want to take a look here:

http://www.sqldts.com/default.aspx?102