Re: output header and trailer?
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 06/04/04
- Next message: Allan Mitchell: "Re: Web interface calling DTS package with parameters"
- Previous message: imani_technology_spam_at_yahoo.com: "Web interface calling DTS package with parameters"
- In reply to: Kevin3NF: "Re: output header and trailer?"
- Next in thread: Darren Green: "Re: output header and trailer?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 4 Jun 2004 22:40:55 +0100
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@NopeIDontNeedNoSPAM3NF-inc.com> wrote in message news:urK1j$mSEHA.3580@TK2MSFTNGP09.phx.gbl... > 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@no-spam.sqldts.com> wrote in message > news:%23dJiJKmSEHA.3596@tk2msftngp13.phx.gbl... > > 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@discussions.microsoft.com> wrote in message > > news:E8C305C1-AF64-4D82-980F-1ECC140CBBF3@microsoft.com... > > > 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? > > > > > > > > >
- Next message: Allan Mitchell: "Re: Web interface calling DTS package with parameters"
- Previous message: imani_technology_spam_at_yahoo.com: "Web interface calling DTS package with parameters"
- In reply to: Kevin3NF: "Re: output header and trailer?"
- Next in thread: Darren Green: "Re: output header and trailer?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
