You could export the info into a spreadsheet then use an ActiveX script to rename the file.  This means that the file is always available for the package.

Good luck guys.

Already have fourdeuce.com as a favourite to keep an eye out for what your doing next.

That sounds like the easiest way.  (Anything for an easy life )

Could it be that there is a null record already in the table?

The table allows nulls into UserName but the index based on it is unique.

As Bill said DTS does not like open files so another option rather than a separate Acces database would be a VB front end.

I have an Access front end whose tables...

Can you connect using the IP?  Does tracert <servername> connect?  I recently had a similar problem and ended up having to put entries into my hosts file as for some...

I agree with Yelena in at least letting everyone involved know that the problem was resolved.  I'd be inclined (if I found a solution on another site.

I only use EM to create/edit DTS packages now.  Everything else is done via the Management Studio. 

I love the ability to modify without having to script out an ALTER...

Does the specified user have sufficient privileges to execute the package?  If you schedule the job to run with your ID does it run?

John

Or, if you can't get that sorted out (I can never get it to work on our system)

http://sqldev.net/xp/xpsmtp.htm

Cheers

John

The problem can be around security for the slammer worm, and a dll called DBNETLIB.dll. When this file is out of date, Server 2003 and perhaps SP2 on XP will actually disable...

http://www.databasejournal.com/features/mssql/article.php/3404791

The account has to be the package owner, but not much else. (I think)

John

This site has a list of the files required to redistribute a dts package:

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

I created a self extracting zip file to install the files on target pc's and a batch...

I always use DTS with an ActiveX script and the FileSystemObject to move/delete/rename files.  Moving files first then renaming  (adding the current datetime), works every time for me.