Have you tried this ?

http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx

USE master

go

EXEC sp_grantlogin 'BUILTIN\Administrators'

go

EXEC sp_defaultdb 'BUILTIN\Administrators', 'master'

go

EXEC sp_defaultlanguage 'BUILTIN\Administrators', 'us_english'

go

EXEC sp_addsrvrolemember 'BUILTIN\Administrators', 'sysadmin'

go

IF EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname='BUILTIN\Administrators')

    PRINT '<<< CREATED LOGIN BUILTIN\Administrators >>>'

ELSE

    PRINT '<<< FAILED CREATING...

Hi Margaret. You may also have to grant the db_ddladmin role to that user in the database you are doing the bulk insert.

Try that.

You might try querying @@rowcount.  It should contain the number of rows in your result set.

Thanks John, the package owner is set to a database account with sysadmin privilege. 

If I drop the DTS job and reschedule it, eveything works fine.  It's like the scheduler...

I'm not sure if this is what you are after or not, but check out master..sp_addserver.  Once you run the proc with your new server name, you will have to...

If the result of select @@version is returning...

Microsoft SQL Server  2000 - 8.00.2039 (Intel X86)  \tMay  3 2005 23:18:38  \tCopyright (c) 1988-2003 Microsoft Corporation \tStandard Edition on Windows NT 5.2...

   If I configure the "log shipping" or "backup the transactions log in the 2nd server" in regular basis (every 20 minutes), do you think the performance will be affected?

I backup...

> We have been sucessful using BLAT (see http://www.blat.net) on SQL7, SQL2000 and SQL2005

I also use blat and have had great success with it.  PLUS... its free.