Is there a way to output header and trailer info when exporting a text file when using a DTS package? Any suggestions? Has anyone done this before

Personally I would export to 3 files

Header.txt
Data.txt
Footer.txt

I would then do

COPY Header.txt + Data.Txt + Footer.txt AllTogether.txt



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

before?

Thanks Allan. Can all of this be done using DTS? Preferably one package? I'm new to DTS, just got handed the job.

I have seen some documentation about writing headers in the "pre source
data" phase of a multi-phase DTS pump, but was never able to get it working.

Allan...have you done anything like that?

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Yep you can do that as well. I prefer the other method as I think it
cleaner.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Kevin3NF" <KHill (AT) NopeIDontNeedNoSPAM3NF-inc (DOT) com> wrote

In message <urK1j$mSEHA.3580 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Kevin3NF
<KHill (AT) NopeIDontNeedNoSPAM3NF-inc (DOT) com> writes
Has anyone got a working example of this method? Never got it working
myself.


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

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

I remember reading something sometime that this was possible but then
remembered I'd played but couldn't remember if I got it to work. The main
problem is that once the package fires it opens the connection and text
files being as they are do not like you trying to open them again. This is
where I believe we get the "Permission Denied" error.

Maybe there is a property of the text file that allows the text file to be
used by two people at the same time ????


Anyway this was my test and no it didn't work


Function PreSourceMain()

dim fso, tStream

set fso = CREATEOBJECT("Scripting.FileSystemObject")

set tStream = fso.Opentextfile("c:\HeaderAndFooter.txt",2)

tStream.WriteLine "Header Row"

tStream.Close

PreSourceMain = DTSTransformstat_OK
End Function


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote