SSIS -Export Files from SQL Table To Folder [ How To Use Export Column Transformation In SSIS ]

Scenario:

We have saved different type of files such as Excel, Image, Text into SQL Server Table. We want to export them to folder. The folder path with file name is saved in FileName column.

Solution:

We will be using Export Column Transformation to save files from Sql table to folder. Let's start with step by step approach

Step 1:
Bring Data Flow Task to Control Flow Pane and then bring OLE DB Source and write query as shown

SQL Command : Select  FileName,[File] from dbo.ImportFiles
Step 2:
Bring Export Column Transformation to Data Flow Pane and then connect OLE DB Source to it. 
In Extract Column map it to File data column and File Path Column to where you want to save that file.

Final Output: 
Let's run our SSIS Package and check the Archive folder if the files are exported to folder successfully.

All the four files are exported to Archive Folder successfully from Sql Server table.

7 comments:

  1. Replies
    1. IEEE Final Year Project centers make amazing deep learning final year projects ideas for final year students Final Year Projects for CSE to training and develop their deep learning experience and talents.

      IEEE Final Year projects Project Centers in India are consistently sought after. Final Year Students Projects take a shot at them to improve their aptitudes, while specialists like the enjoyment in interfering with innovation.

      corporate training in chennai corporate training in chennai

      corporate training companies in india corporate training companies in india

      corporate training companies in chennai corporate training companies in chennai

      I have read your blog its very attractive and impressive. I like it your blog. Digital Marketing Company in Chennai

      Delete
  2. I feel SSIS is the best way of providing solutions about very complex IT problems.I truly feel one needs to carve out and study its utilities as much as possible.

    SSIS Postgresql Read

    ReplyDelete