I have a package which loads data from a flat file source to an OLEDB destination, which is executed successfully and data is loaded perfectly.
But later when the data in the flat file source is modified i.e. if an extra column gets added to the text file, the package is throwing an error because it is unable to detect the extra added column.
How can i avoid this error??? I need my package to execute successfully ignoring the changes(added columns) happened in the flat file source.
Please provide me wth your suggestions and solutions....
Thanks in Advance!!
View Complete Post