Using SQL Server Intergration Services (SSIS) can you read a file from a FileStream column in SQL Se

Posted by tbrovold on Stack Overflow See other posts from Stack Overflow or by tbrovold
Published on 2010-03-18T21:21:51Z Indexed on 2010/03/18 21:31 UTC
Read the original article Hit count: 405

Filed under:
|

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?

© Stack Overflow or respective owner

Related posts about ssis

Related posts about sql-server