dcsimg
Results 1 to 4 of 4

Thread: DTS to BAS

  1. #1
    Join Date
    Jan 2009
    Posts
    2

    DTS to BAS

    I wrote a vb6 program to export all of the access databases in a folder to sql server 2000. Now I need to do the same thing for sql server 2008. My old program does not work. Originally I just used the sql server import wizard to create the bas file. Is there an equivalent for sql server 2008? If not, any ideas on how I could do this?

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Build ssis package then you can run package with dtexec.exe.

  3. #3
    Join Date
    Jan 2009
    Posts
    2
    I created an SSIS package and then opened dtexec.exe. How do I get that into a .bas file?

  4. #4
    Join Date
    Sep 2002
    Posts
    5,938
    You can run the package with dtexec in your vb program.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •