Using SQL Server Intergration Services (SSIS) can you read a file from a FileStream column in SQL Se
- by tbrovold
I am trying to create a tool that I can upload different types of files "csv", Excel, XML and load those files into a FileStream column in the database as "Source" untouched over the web. Then using SSIS on the server I want to create a package that will process that file to be loaded into other tables to be used by the web application.
Is it possible to have SSIS read a file from FileStream column? if so how?