On Jan 24, 4:37 pm, "Allan Mitchell" <a...@no-spam.sqldts.com> wrote:
> For the sake of speed I would still stage. I would then use a SET based
> statement to flag the appropriate rows.
>
> --
>
> Allan Mitchellhttp://wiki.sqlis.com|http://www.sqlis.com|http://www.sqldts.com|http://www.konesans.com
>
> "pomarina" <mpoberez...@harrisinteractive.com> wrote in messagenews:1169674360.323751.160820@s48g2000cws.googlegroups.com:
>
>
>
> > HI Allan,
> > I am not removing bad rows from the flow, I mark them with the
> > exception code, because I apply other rules and I need to know all
> > reasons why the row is bad. What do you think is the best solution in
> > this case in your opinion?
> > Thanks
>
> > On Jan 24, 2:26 pm, "Allan Mitchell" <a...@no-spam.sqldts.com> wrote:
> > > It may be easiest and indeed quickest to dump your files into a staging
> > > table in SQL Server. You can then use TSQL to get the rows you do not
> > > want and remove them. I can think of a couple of ways to do this in the
> > > pipeline but none of them pretty or particularly efficient.
>
> > > --
>
> > > Allan Mitchellhttp://wiki.sqlis.com|http://www.sqlis.com|http://www.sqldts.com|http://www.konesans.com
>
> > > "pomarina" <mpoberez...@harrisinteractive.com> wrote in messagenews:1169652539.071776.213900@q2g2000cwa.googlegroups.com:
>
> > > > Hi,
>
> > > > In my control flow I am returning a result set from the sql db
> > > > containing some words. When I process incoming files I need to reject
> > > > rows if email column matches (not an exact match) any of these words.
> > > > I hoped I can create ascriptto loop each row through the recordset I
> > > > got in the control flow, but can not get it to work. Is it even doable
> > > > what I am trying to do? Thanks in advance for any help- Hide quoted text -- Show quoted text -- Hide quoted text -- Show quoted text -