How to Store the Image located in Another system i

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

Transact-SQL (2012)

How to Store the Image located in Another system i

Author

Topic

Arunraj
Starting Member

18 Posts

Posted - 2015-01-12 : 05:25:36

Hi Friends,

I have the Image in FTP Server Folder and i need to insert that image into my local database.
How can i do this I tried with the below Query but i shows the errors as below.
Please help me to solve this solution.

--INSERT INTO AcademyStudents (ImageURL)
--SELECT BULKCOLUMN FROM OPENROWSET(BULK'https://iconic-solutions.net/OTA/test/images(1).jpeg',Single_Blob) AS BLOB
--Where StudentIdentificationNum = 2
--GO

GOt Error
;
Cannot bulk load because the file "https://iconic-solutions.net/OTA/test/images(1).jpeg" could not be opened. Operating system error code 123(The filename, directory name, or volume label syntax is incorrect.).

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-01-12 : 09:13:43

From: http://msdn.microsoft.com/en-CA/library/ms190312.aspx

'data_file'

Is the full path of the data file whose data is to be copied into the target table.

you can't use http here. You need to specify a local drive or network share

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources