Hi,

I am trying to create a DTS package that exports a table to
a text file from a ASP or ASPX page. Every attempt has failed (copy failed). Currently I am trying to create this
file in the directory that contains my .net application.
Is there a better way to accomplish this task?

Paul

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

What was the error for these failures ?

Execute a package from Active Server Pages (ASP)
(http://www.sqldts.com/default.aspx?207)


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

Hi Allan,

Thanks for the response. The message is:

Package Failed
Package Copy Data from Agencies to c:\webhost4life_aspnet\aci1\agencies2.txt Step failed.

I can load a text file manually to this dir via FTP. I suppose I could add error handling logic if necessary to better determine the root cause of this error.

Best regards,
Paul Zimmerman


************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Remember in DTS everything, well nearly everything, is relative to the place
you push the button. So a personal drive mapping of X:\MyFiles\

may have no meaning to anyone else other than you.



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"paul zimmerman" <paul (AT) musicmantech (DOT) com> wrote

error.