78376

New Excel file with different format want to import data to sql table using ssis

Question:

this is my file please tell me how can I insert date and price cell C4 and C21 into table please help I took excel source and setsOpenRowSetproperty toSHEET$C4:C21` but which is giving me only one column and invalid data also please help. <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" />

Answer1:

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.

Recommend

  • Deploying GWT app from GAE to Tomcat
  • Rows to Columns SQL Server
  • XML Catalog file failing to resolve
  • Create directory tree with forward slash in directory name [closed]
  • Can I break down a large-scale correlation matrix?
  • store in char column getting from decimal column in db2
  • simple Feed forward (newff) network in MATLAB
  • Expression simplification in SymPy
  • Encoded unicode characters lost
  • How do I avoid redefining the parent element class in CSS
  • Why is 0x20 subtracted from the stack pointer in the prologue of this function's code?
  • Lua Torch7 array index notation
  • .Net TextBox With AutoComplete and custom sorting (not alphabetical)
  • Morphological Reconstruction in OpenCV
  • CSS while hover a div how to display other class(or) div?
  • R sqldf renaming a field in a select statement
  • Available space left on drive - WinAPI - Windows CE
  • JQuery .html() remove line break on IE 8
  • SAXReader not re-ecape characters
  • Spring boot 2.0.0.M4 required a bean named 'entityManagerFactory' that could not be found
  • Read text file that is not in the main package in a runnable jar
  • Roxygen error “Skipping invalid path”
  • CakePHP ACL tutorial initDB function warnings
  • Unable to get column index with table.getColumn method using custom table Model
  • How can I set a binding to a Combox in a UserControl?
  • custom UITableViewCell with image for highlighting
  • Groovy: Unexpected token “:”
  • Replace value with Factor in r data.table
  • Exception “firebase.functions() takes … no argument …” when specifying a region for a Cloud Function
  • How to access EntityManager inside Entity class in EJB3
  • Using variable in a value field in jMeter
  • Repeat a vertical line on every page in Report Builder / SSRS
  • Javascript simulate pressing enter in input box
  • Importing jscolor library in angular 2
  • Numpy divide by zero. Why?
  • A cron job substitute?
  • How does Linux kernel interrupt the application?
  • How to get NHibernate ISession to cache entity not retrieved by primary key
  • How can I use `wmic` in a Windows PE script?
  • Unable to use reactive element in my shiny app