Importing Excel sheet into SQL file with images

• raviwill

  Newbie

  Points: 3

  More actions

  November 11, 2010 at 4:59 pm

  #242790

  I want to convert an Excel sheet into a SQL File through SSIS. The Excel sheet I am using has images, texts and numbers.

  When I make a Excel Source in the Data Flow, images are not being copied and its replaced by Null.

  Image is larger than the text so it is taking more than one row to actually fit a row. So all the row image is covering its coming as NULL.

  Is there any way to work around this.

  Thanks

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  November 12, 2010 at 11:43 am

  #1250180

  As far as I know, this is not possible with SSIS.

  Maybe you can script it with .NET, but my knowledge is pretty limited on that part.

  What do you exactly mean with SQL File?

  You can import the rows with SSIS, but I'm afraid you'll have to import the images with another method.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP