this is my file please tell me how can I insert date and price
C21 into table
excel source and setsOpenRowSet
but which is giving me only one column and invalid data also
<img alt="enter image description here" class="b-lazy" data-src="https://i.stack.imgur.com/8y9FO.png" data-original="https://i.stack.imgur.com/8y9FO.png" src="https://etrip.eimg.top/images/2019/05/07/timg.gif" />
You may achieve this using a script task in your package. But consider using SSRS instead. I think this is what SSRS made for.
With SSRS you can make a report using BIDS or also you can create a local report with Visual Studio inside of an (e.g.) ASP.NET application. With the ASP.NET ReportViewer component you can visualize your report and export it to Excel as well. You can even export programmatically if you should do this.
<a href="http://www.codeproject.com/KB/webforms/ReportViewer.aspx" rel="nofollow">Here</a> is a tutorial how to use SSRS together with ASP.NET ReportViewer. <a href="http://beyondrelational.com/blogs/viral/archive/2010/07/09/generating-ssrs-reports-programatically.aspx" rel="nofollow">Another</a> turorial for how to use exporting functionality.