Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SSIS importing images

Author  Topic 

tomislavg
Yak Posting Veteran

51 Posts

Posted - 2010-09-08 : 04:44:33
Dear All, I need your assistance.

I have one table in the SQl 2005 called Employees and in that table there is 'Employee_id' and 'images' column, no images of the employees are stored inside the table.
My goal is to import the photos in the image field. Good thing is that the name of the photos matches the Employee_id. Example "Employee_id.jpg"

How do I the import them in the table, thru SSIS or...? and how to specify that that photo should go in the correct Employee record with the right id column.

Thank you in advance
   

- Advertisement -