Hi, I am calling a dts pacakge from an asp.net page to copy data from
sql server to
a visual fox pro table.

In the step where the program gets the data from sql server, I get the
following error

"Login Failed For User ''(NULL)" Reason. Not Associated With a Trusted
SQL Server Connection"

but I am not using a trusted connection, I am using the default
connection as seen below

pckg.LoadFromSQLServer(server, usr, pwd,
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , , , , pckgName, "")


I searched this on the internet and here's what I found

1) Add <identity impersonate="true" /> to web.config

I made this change, but then when I ran the program, I got an "unknown
error".

2) change the authentication settings to Mixed authentication mode
under security tab in the sql server properties.

The sql server is already running nder this mode.

Any help will be appreciated.

Thanks,