Filter Through Text File
This tool will delete all records from your table which contain values
which matches those from a text file. For example, you can remove the
e-mail addresses from the table using the remove list you have in the
text file.

Connection
Sets the database connection properties. This option allows you to choose
the name of the connection from the drop-down list.
Table name
Sets the name of the table.
Column name
Select a column to search through all records.
Action
Remove
Removes the matching
values from the table.
Select
Selects the records
in the table that contain values from the text file.
Create Table
Creates a new table with the results.
Text file location
Specifies the location of the text file.
Related Topics:
Advanced settings
Schedule package
for later execution
Scheduling options
Repair E-mail Addresses
Search and Replace
Compare Tables
Filter Records
Remove Duplicate Recipients
Remove Duplicate Records
Execute SQL Query
|