May 19, 2008 at 11:09 am
I need to import a bulk amount of tif files into a SQL DB. I'm using MS SQL Enterprise Manager version 8.0. There are 500+ tif files all pretty small under 50k.
I am having trouble writing the script for the import. Let me explain what I need the script to do and hopefully someone can point me in the right direction. I think javascript will be the easiest to accomplish this.
Each tif has a unique filename which matches empid in the employee table. (e.g. employee has an empid of 001 and the image file which relates to the employee is 001.tif)
The script needs to loop through and compare each filename with the field empid in the employee table.
After the script compares it needs to place the image in the appropriate signature field.
The signature field is in the same table as empid. I have been struggling with this problem for the past couple days and really need help. Thank you in advance.
Matt
P.S. If there is a different way of going about the import I am open to any ideas.
May 19, 2008 at 11:14 am
I just realized this should have been put into the SQL Server 2000 general discussion. Sorry about that.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply