DTS Wizard and Dynamic change of Access database


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: DTS Wizard and Dynamic change of Access database

  1. #1
    Bill Lista Guest

    DTS Wizard and Dynamic change of Access database


    I frequently have the need to import data from MSAccess into SQL Server 2000.
    I use the DTS wizard to create the package and save it to the server. It
    is necessary for me to map all the columns because either the column names
    are different, or due to hyphens vs. underbars, it does not automatically
    map correctly. The problem is that the MSAccess source databases are not
    usually in the same file location, or they have different names, but the
    destination SQL database and structure is always the same. The MSAccess table
    structure is also the same and contains about 135 tables, it just does not
    always reside in the same file location. Question, is there a way to easily
    change in DTS what the MSAccess database name (file name) is and simply change
    that value to run a new import?

  2. #2
    Euan Garden Guest

    Re: DTS Wizard and Dynamic change of Access database

    Darren has an example of dynamically changing connections are runtime on
    http://www.swynk.com/friends/green.

    -Euan

    "Bill Lista" <lista_bill@us.arthurandersen.com> wrote in message
    news:3acca996$1@news.devx.com...
    >
    > I frequently have the need to import data from MSAccess into SQL Server

    2000.
    > I use the DTS wizard to create the package and save it to the server. It
    > is necessary for me to map all the columns because either the column names
    > are different, or due to hyphens vs. underbars, it does not automatically
    > map correctly. The problem is that the MSAccess source databases are not
    > usually in the same file location, or they have different names, but the
    > destination SQL database and structure is always the same. The MSAccess

    table
    > structure is also the same and contains about 135 tables, it just does not
    > always reside in the same file location. Question, is there a way to

    easily
    > change in DTS what the MSAccess database name (file name) is and simply

    change
    > that value to run a new import?




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center