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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2012-05-02 : 11:54:13
|
| Hi,In ssis package I have a flat file connection which connects to .csv file.The textqualifier is " i.e. double quotes.Each .csv file has fields with data.At the end of each .csv file, there is a long text i.e. "This is the end of the data..."In the process where I place the data from the file connection to the database table, how can I ignore the last text which is i.e. "This is the end of the data..."This is because this text appears in the first column of the .csv and therefore the ssis complains that the text is too long, etc because it tries to put it into the first column in the database table.Question:How can I ignore the text which appears at the end of the .csv files.Note that this text is the same at the end of each .csv file.Thanks |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-05-02 : 11:59:15
|
| can u post some sample data please?<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-02 : 20:24:17
|
| whats the delimiter that comes before this text. is it consistent?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
ssis error to import file