Import af 10000+ billeder

look at DTS (data transformation services)

terry > jeg har kigget lidt på det, men kan ikke umiddelbart se hvordan det skal løses. Kan jeg få dig til at være lidt mere specifik med hensyn til DTS

I cant be more specific as I have never tried this although I am resonable sure that it could be done using DTS. In DTS it is possible to read files etc. so I would assume that it could be done. It would take some programming and I dont want to get invloved with that as it would take far too long.

Something else, is it necessary to have the picture files in the database, is it not possible to have them placed on a file server and only store the path+file name in the dB?
You could also use Access or VB for doing this if you are more at home with these for programming.

OK tak for hjælpen.

problemet er at vi er ved at flytte en masse informationer fra et gammelt system til et nyt, som kræver at billederne ligger i en MSSQL database.

Jeg prøver lige at rode lide mere med DTS ellers må jeg igang med noget programmering, jeg havde ellers håbet på at undgå det.

One of the problems is getting hold of the filename and storing this in the dB.

this may be of use, search for this in Books Online.

xp_cmdshell

I noticed this example
DECLARE @cmd sysname, @var sysname
SET @var = 'dir /p'
SET @cmd = 'echo ' + @var + ' > dir_out.txt'
EXEC master..xp_cmdshell @cmd


and if you can get the informatin of your file names into a table then your well on the way.

informatin = information