Import gif file to SSIS and save binary, filename etc to table fields

I need to use SSIS to cycle through a bunch of .gif images in a folder and import each one into a single row in a table, which contains fields such as filename and size, but more crucially, the binary from the file.

I will use a foreach loop to cycle through the files, and probably a script transformation to assign variables to certain outputs but what I am having difficulty with is dealing with the .gif file itself and handling the binary within the data flow. I'm not sure:

  1. what connection manager to use and how to configure it
  2. what data source to use

From googling this I think I need to also use a column transformation at some point to handle the binary but it's not obvious how I use or configure it.

If anyone has any experience with this, some pointers would be much appreciated.

Glenn

Answers


In your datasource or using a derived column transform you work out the path to your file you need to import. Then add in an Import Column Transformation, selecting your file path column. The Import column transform needs to have a binary column which can then be used in the dataflow destination. There's an example here


Need Your Help

How can i make one thread out of several run for maximum time(minimum time in waiting queue)?

java multithreading concurrency

So, I am building an application(for machine simulator). It consists of 8 threads.Out of which one thread represents main machine. I want this thread to run for maximum time i.e. maximum CPU time s...

An array of sorting algorithm

php arrays algorithm sorting

I have a multi-dimensional array, the structure is like this: