Import Column

• sqlgreenhand

  SSCommitted

  Points: 1639

  More actions

  December 13, 2010 at 9:33 am

  #388428

  I am using SSIS Import Column to import a text file with jpg images.

  ImageFile

  1.jpg

  2.jpg

  3.jpg

  My SQL table has three columns --> ID (identity), FileName(varchar(100), ImageFile (Image), when I import

  the images only it works. BUT when I try to add the file names (in order to correspond filename/image) to FileName errors occur.

  Is Import Column designed to import only one column!? And Export Column has two columns - Path and FileName !

  Please let me know.

  Thanks.:angry:

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  December 17, 2010 at 3:53 am

  #1263982

  Here is a small tutorial:

  http://www.bimonkey.com/2009/09/the-import-column-transformation/

  Read it through and see if you missed something 🙂

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

• sqlgreenhand

  SSCommitted

  Points: 1639

  More actions

  December 17, 2010 at 1:37 pm

  #1264235

  Thanks.