using Stored procedure or DTS script

#1

I am looking at the pros and cons of using Stored procedure or DTS script.

I want to select some records, Create a file, FTP the file. Run some dos commands.

Any reference to convince skeptics will be greatly apreciated.

#2

DTS would give you a nice graphical representation.

DataPump task to a text file
Use an ExecuteProcess task and FTP.exe
Use an ExecuteProcess task and a batch file.

--

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

"Heds" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

I am looking at the pros and cons of using Stored procedure or DTS script.

I want to select some records, Create a file, FTP the file. Run some dos
commands.

Any reference to convince skeptics will be greatly apreciated.

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

using Stored procedure or DTS script

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

using Stored procedure or DTS script - 11-11-2003 , 02:36 PM

Re: using Stored procedure or DTS script - 11-12-2003 , 08:56 AM