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: 410
ssis
|sql-server
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