In my ssis Package i am using Excel Source Component.I am executing the package from web application.When i execute the package in the error log I am getting the below error.
There was an error with output column "RiskName" (9493) on output "Excel Source Output" (9438). The column status returned was: "Text was truncated or one or more characters had no match in the target code page.".
I am able to resolve this issue if i could open the package in the BID and manually go and change the column datatype matching with the ExternalMetadata column.But I could not do this each and every time since i am running the package from web application not from the BID.I am selecting the Excel file name and sheet name from the application and passing through package variable.
I have designed the package by selecting an Excel sheet.But when i select different excel sheet from outside its metadata column datatype mismatch is happening.How can i resolve this issue without reopen and edit the Excel source column in Package.
At the execution time can i access the Metadatacolumn of Excelsource component and change it?
Thanks in advance.