Home Forums Data Warehousing Integration Services Importing CSV into a Database RE: Importing CSV into a Database
Lempster
SSCoach
Points: 15651
More actions
January 3, 2014 at 7:14 am
#1677265
Yep, good idea, you could use a Conditional Split transform with a condition like 'LEFT(columnname,1) != "T"
If you've got hundreds of thousands of rows in your text files, it might be a bit slow mind.