Flowing Fount of Yak Knowledge
Posted - 05/02/2012 : 11:54:13
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.
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.