run sql-statments in dts

#1

Hi all,

Any ideas in how to run sql-statment in a dts? The output need to be sent to a file.

TIA

#2

In article <5F0284EC-33C8-45FE-93FC-1D818018B4FE (AT) microsoft (DOT) com>, David
Velasco <anonymous (AT) discussions (DOT) microsoft.com> writes

Quote:

Hi all,

Any ideas in how to run sql-statment in a dts? The output need to be
sent to a file.

TIA

The Execute SQL Task is all about executing SQL statements.

Add a connection to your package
Add an Execute SQL Task to you package, set the connection, and set the
statement.

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

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

run sql-statments in dts

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

run sql-statments in dts - 12-03-2003 , 03:51 PM

Re: run sql-statments in dts - 12-03-2003 , 04:51 PM