O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with BLOB fields: Export Column and Import Column transformations

Resorting to BLOB fields as storage medium for physical files is a common need nowadays. SQL Server support BLOB data in two standard types as Image or Varbinary. SSIS also provides two transformations to work with BLOB fields: Export Column and Import Column.

Export Column will fetch physical files from BLOB data, whereas Import Column feeds the physical file to an Image or Varbinary field.

In this recipe we use both Export Column and Import Column transformations. With Export Column we fetch actual files from the Document table in the AdventureWorks2012 database. With Import Column, we load physical files into the Image type field of the database table.

Getting ready

Create ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required