Insert email file link in sql server

I save the outlook email to shared folder and i want insert this ‘SharedFolderPath’ into sql as hyper link.
so when I click on file path in SQL management studio, it navigate to file folder path.

I use Execute Non Query activity and sql string is :

UPDATE table Set [FileHyperlink] =‘SharedFolderPath’ Where ID=10

Any idea how should i modify my query?


Hi ,

I came across this blog for hyperlink of URL , Try this for Sharepath.