I got a very strange situation:
I wrote code to export data to csv file within ASP using VBScript. (My
VBScript code was based on the VB code that was created by "Save As" to
"Visual Basic File" in DTS Designer.) In debug mode, I had no problem to
export data. However, the Copy-data step failed when I open this ASP page
directly in IE. I tried to export data to xls file with the same method, and
I had no problem to export data in both debug and non-debug mode.

Anybody has any clues for this problem? Thanks.

In message <6183EC2A-3176-41AF-BD0D-2E6EF2CC8EF5 (AT) microsoft (DOT) com>, X.
Zhang <XZhang (AT) discussions (DOT) microsoft.com> writes
It is probably die to the security context that the package is running
under. You are best of using impersonation, perhaps through COM+. This
is explained a bit further here, on page 2-

Execute a package from Active Server Pages (ASP)
(http://www.sqldts.com/default.aspx?207)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

But why does it work while running in debug mode? And why does it work for
XLS file (both XLS and CSV in the same security context)?

PS: I tried to save the package to a storage file, and then
LoadFromStorageFile. I thought in this way I can bypass some SQL Server
security stuff. But it still did not work.

"Darren Green" wrote:

In message <79B01EF5-5DF3-43CD-8B3A-74CC7670B969 (AT) microsoft (DOT) com>, X.
Zhang <XZhang (AT) discussions (DOT) microsoft.com> writes
This means you are running on the same machine as EM using the
credentials of the logged on user. Quite different to running on the IIS
machine using the IWAM account.


When using Local Storage (SQL Server) to store your packages, you need
some connection credentials to connect to the server and load the
package, or really just run a select statement to grab a blob of data.
This gets the package into memory on the client. You then execute the
package, and the loading credentials have no bearing at all on the
connections inside the package and how they are used.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org