Tuesday, June 21, 2016

FileTable External Process Like Zip using T-SQL

Leave a Comment

Has anyone ever tried to use tsql to launch external processes against files in a FileTable? I have not been able to find anything so if may not be possible.

In particular I am looking into PGP and ZIP operations. My backup plan is to use C# in combination with queries against the filetable.

I am curious to know if it can be done with T-SQL instead. I have looked at xpcmdshell to launch a process but many people recommend against this.

Thoughts and ideas are much appreciated.

1 Answers

Answers 1

Can set folder to compressed (or on EFS)?

See http://blog.brucejackson.info/2013/04/sql-file-table-step-by-step.html

If You Enjoyed This, Take 5 Seconds To Share It

0 comments:

Post a Comment