> I have three Stored Procedures in DTS, in which first stored procedure
> is writing header row in destination file with four column.
> Second procedure writing data into the destination file with 15
> columns
> Third stored procedure writing trailor row in data file with 4 column.
> problem is if i map the resultant column of first stored procedure
> with destination file and then map resultant column of second stored
> procedure with destination file previous mapping is overwritten.
>
> is there any way by which i can have three different rows with
> different number of columns in each row and different sizes of
> columns.
>

Allan Mitchell wrote:

> Hello Dipa,
>
>
> Here's an idea
>
>
> Throw them into 3 seperate flat files and then use the DOS COPY command to
> add them together in a seperate file.
>
>
> Allan
>
>
> > I have three Stored Procedures in DTS, in which first stored procedure
> > is writing header row in destination file with four column.
> > Second procedure writing data into the destination file with 15
> > columns
> > Third stored procedure writing trailor row in data file with 4 column.
> > problem is if i map the resultant column of first stored procedure
> > with destination file and then map resultant column of second stored
> > procedure with destination file previous mapping is overwritten.
> >
> > is there any way by which i can have three different rows with
> > different number of columns in each row and different sizes of
> > columns.
> >