Results 1 to 3 of 3

Thread: Code to Import Bank Files (BAI, BAI2)

  1. 10-31-2006, 09:13 AM #1
    johnsonp
    johnsonp is offline Registered User
    Join Date
    Oct 2006
    Posts
    3

    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!
    Reply With Quote Reply With Quote
  2. 10-31-2006, 10:07 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You can add vbscript in dts package.
    Reply With Quote Reply With Quote
  3. 11-01-2006, 09:53 PM #3
    johnsonp
    johnsonp is offline Registered User
    Join Date
    Oct 2006
    Posts
    3
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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