Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SSIS and Import/Export (2008)  Generate trimmed-down file.

Author  Topic  tmccar Starting Member 27 Posts Posted - 2011-09-17 : 08:26:20 Not sure if this is the correct forum. (Apologies if not). I have an excel file with 117,000 rows & 51 columns and another file with 66,000 rows and just one column. This column is common to both files. How can I generate a third file that is effectively a trimmed-down version of the first, with only those records that match the single-column file?