开发者

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

I am trying to create a tool that I can upload different types of files "csv", Excel, XML and load 开发者_StackOverflow社区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?


In the data flow, you'd use an Import Column transform (usage described here: http://agilebi.com/cs/blogs/jwelch/archive/2008/02/02/importing-files-using-ssis.aspx) to pull the file into the data flow. It brings it in as type DT_IMAGE, which can be written to a FILESTREAM column, which is of type varbinary(MAX), using the OLE DB Destination.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜