I have a DTS package I am trying to modify, and I am having a couple
of problems - possibly security related.

I have an OLE-DB connection to a database, and I want to modify
several exports to an Excel file on the same system. Initially, when
I attempted to display the properties for one of the exports, I got
the error:

Error Description: Login failed for user '\(null)'. Reason: Not
associated with a trusted SQL Server connection.

The package is run using dtsrun with the /E option, so this is not a
complete surprise, and I am connecting remotely with Enterprise
Manager.

I changed the OLE-DB connection from Windows Authentication to SQL
Authentication - using 'sa', and can display the 'Transform Data Task
Properties' window, but when I click on the Destination or
Transformations tabs, I get the error:

Package Error
Error Source: Microsoft JET Database Engine
Error Description Failure creating file.

When I click on OK, Transform Data Task Properties window goes away.


It has been several years since I worked with DTS, so I am a little
rusty. Any help will be greatly appreciated.

tia
-Bill