I think it is to do with for format of the input file. You're data is in character format and therefore you need to tell bcp that. To use SQLINT...

Change to SQLCHAR in your format file.

Seems find except for table name

i.e.

select fullname

from (select Name + Surname as Fullname from tablea) as a

where Fullname > 'Paul'

order by Fullname

Antares686, where did you get info re RAID5.

We put OS on RAID5 (2 logical drives (C: for OS, D: for SQL)!

"Make sure you turn off the header output, (does anyone know hot do this in query analyzer?)"

Query

Current Connection Options

Advanced

Print Headers (Remove Tick)

Try

DECLARE @sql nvarchar(4000)

SET@sql = 'SELECT * FROM OPENQUERY(SERVER2, ''SELECT val1=db1.dbo.fn_MyFunction(' + @param1 + ')'')'

EXECsp_executesql @sql

Never done this but have you checked the code that returns jobStatus is working OK!.

IS your code running too soon? CurrentRunStep will return 0 if the job step is...

Interesting! What about SQL7, 3 x 18GB drives, 1 controller, RAID5. 2 Logical drives, C: (4GB) for OP Sys, D: (30GB) for SQL. Is this bad practice?

Why not check if row exists in destination table before insert. This is what I do.

I think Antares686 is right. Have you no backup of master prior to rebuild?

However, having a really surreal idea.

MAKE A COMPLETE BACKUP OF SQL (Master,etc.)

Make copy of the DAT file...

Is the error display from your app?

Error 1004 can be caused by trying to open xls with older version of Excel than the one used to create it!

Try looking at the following topic, I believe it holds your answer.

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=7690&FORUM_ID=8&CAT_ID=1&Topic_Title=declaring+variable&Forum_Title=T%2DSQL

Never done this so not much help. However when I have had problems with transferring apps to server where they don't work but do on my workstation. The only advice...

Don't know what ERWin is.

This may sound obvious but when I want to send people my Visio database diagrams I convert them to Acrobat via printing.

The use of IN/NOT IN with sub queries seems to be a common theme.

I have found LEFT OUTER JOINS to be a lot faster than NOT IN (SELECT...)

I would try...