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

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:

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


"Charles Kangai" wrote:

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/lib...ts.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.
================================================== ====