May 21, 2008 at 8:48 am
I will be porting a database from 2000 to 2005 and several stored procedures use the bii utility to bulk insert files into tables.
I heard that bii isn't support in Server 2005. Is that true?
May 21, 2008 at 10:02 am
I have no idea what bii is, but you can use BCP, the BULK INSERT statement or SSIS to bulk import from files to tables.
Greg
May 21, 2008 at 10:07 am
Thanks for the reply
From SQL Server books online
Bii
This sample is a stand-alone console application that mimics the bcp utility that ships with Microsoft® SQL Server™ 2000. Unlike the bcp utility, the bii utility detects when an image field is the destination database field and the input is a filename that can be located in the file system. In this case, instead of loading the filename string into the image field, the program opens the file, loads the data, and inserts the file contents in the image data type field.
May 21, 2008 at 2:19 pm
I can't find it on the SQL 2005 installation CD so it probably isn't included. That doesn't mean it won't work in SQL 2005. If you have a 2005 instance, you could try it. If it doesn't work, you have to try one of the options I mentioned earlier.
Greg
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply