Hi,
I've been working on a store procedure to load a variable length record file into a table by using bulk insert with a format file. Since the record length varies, i'm having a hard time loading it in properly. I wrote a VB script to pad the file to a set record length. Does anyone know if i can call a VB script from a Store Procedure? Or does anyone know a better idea to load a variable record length file into a table?
Thanks!
Kaze



---------------------------------
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
MS Sql Server LazyDBA home page