Want to insert excel file data into table using ssis - format problem

• ashuthinks

  SSCommitted

  Points: 1698

  More actions

  September 18, 2011 at 12:08 pm

  #257546

  image : http://i.stack.imgur.com/KDZ4f.png

  hi I want to take value of date i.e '8/26/2011' , and value of NAV i.e '93737452.52'

  and want to insert into table i'm using 'excel source ' to take excel file made connection now Select 'Data access mode' in 'Excel source editor' as 'SQL command'

  now what command I need to write to get 'date' and 'NAV'value as I have pasted picture of excel file please let me know the further steps

• p.govindaraj

  SSC Enthusiast

  Points: 193

  More actions

  September 19, 2011 at 2:59 am

  #1383190

  Hi,

  If you are selected SQl command then you have to write a query like,

  "Select column1, column2 from sheet1$"

  better you can simply "select table or view" option.

  Govind