Hi,
There's one issue in excel data load using SSIS.
Column having data type value greater that 250, by default dt_text data type is set and it works fine.
Whereas if on second time,value within same column is less than 250 character then the package failed with error needs new metadata changes.
Can anyone give me the solution for this, tried a lot but not able to resolve issue.
Regards,
Pankaj