I think I found the problem. The server that cannot connect has a hot strapped IP with no default "Connection-specific DNS Suffix" therefore you have to fully qualify the servername.

I...

Yes I can.

I have also connected to the target server (64bit) from another machine on the Client server's same domain.

I am busy doing ipconfig checks on the two....

Yes

Yes it is normal. In the properties of the ExecSQL task you can set your connection , if there are more than one in the DTS.

You sometimes do link a...

I cannot wait to cut over to SQL 2005! Why?

error trapping in t-sql!!!!!

Sorry about the typo.. I ment logfile not database.....

No wonder you never posted the error message "unspecified error" Sorry I do not have a clue....

If you designed the script using Query Analyser and that session is still OPEN the table WILL STILL EXSIST....

No Excel does not have to be installed on the server..Plse post the error message 

Firstly backup your database and try

DBCC SHRINKFILE

    ('Databasename',TRUNCATEONLY)

The #Table remains active while your SPID is still open.  Either drop the table or close the session and re-issue script...

Firstly the SQL Server box must have the Oracle CLIENT installed.Then add the oracle alias in the tnsnames.ora file in the ADMIN dir of the oracle installation. Then read up...

I am using the default -  -READ COMMITTED

My problem is that the entire database gets locked. You cannot even browse the sp'S.

Hi,

You can use a DTS package to import a text file. You can use the text file connection object.

If you are importing every minute you might get on ovelap of...

The sp  sp_add_jobserver can be used  at creation but it is at the JOBLEVEL.....