"I need to create a file with static header info (first record), result
set from a query and static trailer info (last record). Here is an
example:

Header Info (Record 1)
Results from query (record 2)
Results from query (record 3)
....
Trailer Info (Record n)

What is the best way to do this? I can create a file with just the
results from a query, but I can't figure out how to get the header and
trailer info into the file. HELP!"

There are a few ways you could do this. You can create three
files: a header file, the data file, a trailer file.Then you
can combine the files into the final file using the DOS copy
command with something like:
COPY Header.txt + Data.Txt + Trailer.txt FinalFile.txt
You could use a SQL statement that unions the header, data
and trailer info.
You could also use the Multiphase Data Pump functionality to
do this.

-Sue

On 24 Feb 2005 15:58:30 -0800, "Tim" <rrichards (AT) exabyte (DOT) com>
wrote:

Hi,

A bit of a variation on the exporting text files with header & trailer info
theme. I currently have a package that exports data from a sql table to a
text file and an ActiveX script that renames the Text File destination
connection at run-time to include the date so that it gets exported as
something like custYYMMDD.txt

I need to add header a trailer and footer record and thought of doing so by
using 3 separate files containing header, data, footer and then using the DOS
copy to combine them: ie. copy header.txt+data.txt+footer.txt final
output.txt - how can I incorporate this into my package and how can I
dynamically rename the final combined file to include the date in the name of
the file?

Any thoughts much appreciated,

Rich

Sue, thank you for your input. I need to use the COPY method, but I
can't figure it out. I have all three of my files written, but I'm not
sure how to use th eDOS copy command in ActiveX, like you mentioned.
Can you provide a snippet?

Thanks!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

If you want to use the DOS copy command, you can use an
execute process task to execute the copy command. Command
would be cmd.exe with the parameters:
/c copy D:\Header.txt+D:\File.txt+D:\Trailer.txt
D:\Final.txt

-Sue

On Mon, 28 Feb 2005 16:18:10 -0800, Jim James
<rrichards (AT) exabyte (DOT) com> wrote:

Sue,
You are great. Now I have this package built and doing what I want. I
can execute it fine. I have users that need to be able to execute it.

How do I call this package from a button in ASP.net? I've never worked
in ASP.net before.

TIA.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi James,
Glad to hear you got things running! I'm pretty sure the DTS
Cookbook for .Net goes through examples of this. You can
find it at:
http://www.sqldev.net/dts/DotNETCookBook.htm

Hope that helps -

-Sue

On Wed, 02 Mar 2005 12:28:09 -0800, Jim James
<rrichards (AT) exabyte (DOT) com> wrote: