January 29, 2014 at 11:20 pm
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
January 29, 2014 at 11:48 pm
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
January 30, 2014 at 3:05 am
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
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy