[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

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
0
Stanton_Roux
Asked:
Stanton_Roux
  • 2
1 Solution
 
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
 
OriNetworksCommented:
i'm sorry, i believe conditional split would accomplish this instead of the derived column.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now