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.
| Author |
Topic |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2010-04-15 : 07:40:57
|
| With a large 904-column unicode flat file to import to SQL Server, I need to do this alongside with a small Excel file with a column of 904 values (Yes, No) in there, to set which columns to pull in as marked yes. To avoid having to manually tick these setting, which transform can I use to get the data in?The eventual result would be just 110 columns.How do I do this, please? |
|
|
|
|
|
SSIS Import