Error while loading into sql database

• vijay.sap1255

  Mr or Mrs. 500

  Points: 592

  More actions

  January 29, 2014 at 11:20 pm

  #287753

  Hi Experts,

  I am facing an error while loading data from flat file into sql server DB using import table.

  My flat file is having path for a image:

  C:\Users\vijayvanamala\Desktop\SSIS Filesature.jpg

  Database table structure:

  CREATE TABLE [dbo].[My_images](

  [ImageID] [int] NULL,

  [Imagepath] [nvarchar](100) NULL,

  [Image] [varbinary](1000) NULL

  ) ON [PRIMARY]

  I have done the reequired in Import column and the connected to data conversion as am facing data type error. then i could able to execute till database and then throwing an error: error code 0xC0209029

  Please view the image and help me find solution.

  thank you and best regards,

  Vijayvanamala

• vijay.sap1255

  Mr or Mrs. 500

  Points: 592

  More actions

  January 29, 2014 at 11:48 pm

  #1684534

  Got Executed.., Changed the database table structure and then executed. Works fine now.

  CREATE TABLE [dbo].[my_images](

  [Image_ID] [int] IDENTITY(1,1) NOT NULL,

  [ImagePath] [varchar](1000) NULL,

  [Image] [varbinary](max) NULL

  ) ON [PRIMARY]

  Check out the difference in structure creation if any one facing this kind of issue.

  Best Regards,

  VijayVanamala

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  January 30, 2014 at 3:05 am

  #1684573

  Good that you found the issue and posted it back. It can help other people who stumble upon this thread.

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