-
Code to Import Bank Files (BAI, BAI2)
Anyone have some code to import bank files to SQL Server 2000 tables in the formats BAI or BAI2? I'm using a DTS package currently, but I'd like to have more control over this by using T-SQL or vbscript or something.
Thanks!
-
You can add vbscript in dts package.
-
Yes, I guess I should have mentioned that. I'm using vbscript in about half a dozen other DTS packages for processing files, but I like to stick with SQL if possible. I'm really just looking for someone who has built a program for processing this particular type of bank file because of it's complexity. And SQL bulk inserts and bulk copies don't work with some bank files because of limitations on how the code looks at row terminators.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|