Select statements output file.

#1

Is there a way that I can get the result of multiple select statements into 1
file from a DTS package ?

Thanks for any help.

#2

If you can't UNION them or something similar, you will probably have to output
multiple files and combine them using an ActiveX task or a simple batch file
along the lines of:
type file1 file2 file3 > desiredoutputfile

(something like that - don't remember the exact syntax)

-Pete

DXC <DXC (AT) discussions (DOT) microsoft.com> wrote:

Quote:

Is there a way that I can get the result of multiple select statements into 1
file from a DTS package ?

Thanks for any help.

#3

Not naturally.

You could pump each statement to seperate file and then use the DOS COPY command to merge the files into another file.

On Wed, 17 Aug 2005 08:10:06 -0700, DXC <DXC (AT) discussions (DOT) microsoft.com> wrote:

Quote:

Is there a way that I can get the result of multiple select statements into 1
file from a DTS package ?

Thanks for any help.

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

Select statements output file.

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

Select statements output file. - 08-17-2005 , 10:10 AM

Re: Select statements output file. - 08-17-2005 , 11:47 AM

Re: Select statements output file. - 08-17-2005 , 01:30 PM