Insert email file link in sql server

Help Activities
,
1

Hi,
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?

Thanks

2

Hi ,

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