Depending on your source, you could Edit the connection manager, then change
Daa Access mode to SQL command, then enter the SELECT statement. Or you could
use conditional split, write one output and discard the other. This second
method is clunky and not suitable. First one is better.
Charles Kangai, MCT, MCDBA
[quoted text, click to view] "michael" wrote:
> Just getting the hang of this SSIS stuff. I have an operational Control Flow
> and Data Flow (Input from Source, Data Conversion, Output to Destination).
> All works fine.
>
> However, I would like to limit the Output to specific rows based on criteria
> (like a SELECT and send the result set to the Output). There must be a way to
> do this but can't seem to find the correct Data Flow Transformation (maybe
> I'm looking for the wrong tool).
>
> Any suggestions?
> --
I see. Adding a SQL command on the Source side would be great, except that
I'm using a flat file as the source. Guess that I'll have to do the work
after the Output to the destination.
--
Michael Hockstein
[quoted text, click to view] "Charles Kangai" wrote:
> Depending on your source, you could Edit the connection manager, then change
> Daa Access mode to SQL command, then enter the SELECT statement. Or you could
> use conditional split, write one output and discard the other. This second
> method is clunky and not suitable. First one is better.
>
> Charles Kangai, MCT, MCDBA
>
> "michael" wrote:
>
> > Just getting the hang of this SSIS stuff. I have an operational Control Flow
> > and Data Flow (Input from Source, Data Conversion, Output to Destination).
> > All works fine.
> >
> > However, I would like to limit the Output to specific rows based on criteria
> > (like a SELECT and send the result set to the Output). There must be a way to
> > do this but can't seem to find the correct Data Flow Transformation (maybe
> > I'm looking for the wrong tool).
> >
> > Any suggestions?
> > --
Hi Michael,
If you are using a flat file as data source, you need to use script
component or script task programmatically for selecting rows.
You may refer to the usage of script component:
Parsing Non-Standard Text File Formats with the Script Component
http://msdn2.microsoft.com/en-us/library/ms345160.aspx ScriptBuffer Class
http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.dts.pipeline.sc riptbuffer.aspx
Sincerely yours,
Charles Wang
Microsoft Online Community Support
======================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================
Don't see what you're looking for? Try a search.
