"SQL Learner" <sqllearner@hotmail.com> wrote in message
news:1173192125.412108.314920@t69g2000cwt.googlegroups.com:

> On Mar 5, 4:16 pm, "Allan Mitchell" <a...@no-spam.sqldts.com> wrote:
> > You could use this if you want
> >
> > RowNumberTransformation
> > (http://www.sqlis.com/93.aspx)
> >
> > --
> >
> > Allan Mitchellhttp://wiki.sqlis.com|http://www.sqlis.com|http://www.sqldts.com|http://www.konesans.com
> >
> > "sqllear...@hotmail.com" <sqllear...@hotmail.com> wrote in message
> >
> > news:1173120358.175979.163580@30g2000cwc.googlegroups.com:
> >
> >
> >
> > > I need to import a flat file as follows:
> >
> > > Column1,Column2,Column3
> > > 1,2,3
> > > 4,5,6
> > > (snip)
> > > 123,456,789
> > > Downloaded fromwww.abcdef.comon 02/28/2007. Total1: 12344556
> > > Total2:
> > > 234523 Total3: 56456 Copyright 2004-2007 by ABCDEF Group LLC. All
> > > Rights Reserved.
> >
> > > The last line is some kind of signature. I have no problems uploading
> > > data lines from 1,2,3 to 123,456,789.
> > > The last line is ignored, which is OK.
> >
> > > I have 2 problems I cannot solve right now:
> > > 1. I need to upload the last line into some other staging table to do
> > > some validation, such as to match totals against my control numbers
> > > and to verify the date.
> > > 2. I need to have line numbers from the text in my target table:
> >
> > > LineNumber,Column1,Column2,Column3
> > > 1,1,2,3
> > > 2,4,5,6
> > > (snip)
> > > 300,123,456,789
> >
> > > I think there should be a transformation to add line numbers, but I
> > > cannot find any so far.
> >
> > > Thanks in advance. BTW, am I asking in the correct newsgroups?- Hide quoted text -
> >
> > - Show quoted text -
>
>
> Allan,
>
> Is your solution similar to the following:
>
> http://support.microsoft.com/kb/908460
>
> If yes, I have a concern: MSDN says "The mycount column does not
> necessarily reflect the actual row number in the original source."
> Does your solution provide a reliable way of numbering lines in a text
> file?
>
> TIA