Ingnoring records when importing from a flat file using a SSIS package

HI There

I am importing from a flat file into a database table using an SSIS package.
I would like to edit the package to exclude any records where the Column values from the flat file is a certain string value.

Ie I would like to import all the records where the column value is not equal to a specific string.

Any help on how to do this would be appreciated.

Thanks
Stanton
Stanton_RouxAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
OriNetworksConnect With a Mentor Commented:
i'm sorry, i believe conditional split would accomplish this instead of the derived column.
0
 
OriNetworksCommented:
I believe you would like a Data Flow Task to grab the import file and then inside of that data flow, you want to add a Derived Column transformation. In there you can use an expression for the column you want to filter out. I'm not 100% on this one but im fairly confident.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.