I have a package set up that successfully imports a csv file into a table in MS SQL 2008 database. It imports data into all columns in that table except for 1. In that last column, I wish to fill it in with whatever date rests in a field in another table. The other table has only 1 record, so I thought somewhere I could say "select fieldname from tablename" and use the result for that last column.
Not sure what the best way to do this would be.