Extract email message from SQL iMAGE Column file


I have uploaded an outlook email message to SQL using:

Column type is 'image'.

UPDATE dbo.AMGR_Letters_Tbl
SET    TextCol = (SELECT *
                FROM   OPENROWSET(BULK 'C:\test\test.msg',
                       SINGLE_BLOB) AS x)
 WHERE Sequence_Number = 182

Now I want to extract the same file as an outlook email message.

Code I used:

DECLARE  @Command NVARCHAR(4000)

SET @Command = 'bcp "SELECT TextCol FROM EsconaTutorial.dbo.AMGR_Letters_Tbl WHERE Sequence_Number = 182" queryout "C:\Test\TEXT.msg" -T -n -S127.0.0.1'
PRINT @Command -- debugging
EXEC xp_cmdshell   @Command

I am unable to open the extracted file .

I get "The file may not exist, you may not have permission to open it.

Shezad AhmedAsked:
Who is Participating?
Eugene ZConnect With a Mentor Commented:
try to use sql format file
see this step=by-step  example how to export image datatype from sql by using bcp
All Courses

From novice to tech pro — start learning today.