Re: output header and trailer?

From: Kevin3NF (KHill_at_NopeIDontNeedNoSPAM3NF-inc.com)
Date: 06/04/04 

Date: Fri, 4 Jun 2004 15:09:47 -0500

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?
> >
>
>

Relevant Pages

  • Re: Variable text file destination name
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... >>Allan Mitchell MCSE,MCDBA, ... >>> destination dynamically to Access or SQL databases I ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS bug (?): Data Driven Query Task incorrectly replaces empty strings with NULL.
    ... DataPump task works as expected so it is not something that DTS cannot ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >> Allan Mitchell MCSE,MCDBA, ...
    (microsoft.public.sqlserver.dts)
  • Re: crazy question....
    ... www.SQLDTS.com - The site for all your DTS needs. ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS bug (?): Data Driven Query Task incorrectly replaces empty strings with NULL.
    ... DataPump task works as expected so it is not something that DTS cannot ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >> Allan Mitchell MCSE,MCDBA, ...
    (microsoft.public.sqlserver.server)
  • Re: Dynamic column mapping
    ... Allan Mitchell MCSE,MCDBA, ... > I have a DTS that reads from multiple text files importing them into a SQL ... > DTS to use the default mapping it uses when I enter the Transformation ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)