Reg : Using DTS tasks from Active Server Pages

#1

I would like to create a comma separated file with the
data taken from sql server tables.
Is there a wasy to use the dts tasks alone (data pump)
from active server pages instead of creating a DTS package
in the SQL Server.

#2

In article <218101c379f2$873ec430$a501280a (AT) phx (DOT) gbl>, Arun wrote:

Quote:

I would like to create a comma separated file with the
data taken from sql server tables.
Is there a wasy to use the dts tasks alone (data pump)
from active server pages instead of creating a DTS package
in the SQL Server.

You are still going to have to create a package with the object model
and just not save it. This would be an expensive way of doing BCP or
OSQL.

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Reg : Using DTS tasks from Active Server Pages

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Reg : Using DTS tasks from Active Server Pages - 09-13-2003 , 07:28 AM

Re: Reg : Using DTS tasks from Active Server Pages - 09-13-2003 , 11:48 AM