Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Error while loading into sql database Expand / Collapse
Author
Message
Posted Wednesday, January 29, 2014 11:20 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, March 07, 2014 4:32 AM
Points: 19, Visits: 50
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


  Post Attachments 
Capture.PNG (2 views, 10.84 KB)
Post #1536175
Posted Wednesday, January 29, 2014 11:48 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, March 07, 2014 4:32 AM
Points: 19, Visits: 50
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
Post #1536181
Posted Thursday, January 30, 2014 3:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:35 AM
Points: 12,208, Visits: 9,172
Good that you found the issue and posted it back. It can help other people who stumble upon this thread.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1536225
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse