Stanton_Roux
asked on
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
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
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.