Post reply

DTS to import data from Pervasive SQL 8 to SQL Server 2000

  • June 14, 2004 at 5:14 am

    #60167

    I woul d like some instructions on how to set up a DTS package to import data from a Pervasive file? table? into SQL Server 2000.  I have just downloaded Pervasive SQL 8 but am very unfamiliar with it. 

    Some step by step instructions would be truly appreciated

     

    Cheers

    Lesley

  • June 14, 2004 at 7:08 am

    #510251

    OK some simple instructions to get you going

    In EM (Enterprise Manager), expand your server

    Select your target database

    Right click on the target database, select All Tasks, Import Data

    You will then see the DTS Wizard which will take you through the steps

    Choose a data source

    use the drop down list to select the Pervasive ODBC driver

    Select the DSN you set up enter appropriate username and password

    Click Next

    Choose a destination

    Leave the destination as Microsoft OLE DB Provider for SQL Server

    The server and database will be selected already

    Change the authentication type is required

    Click Next

    Specify table copy or query

    Here you select whether to pick a table to transfer (all columns)

    or to enter a query is you want selected columns

    Click Next

    Click on Transform

    Here is where you can create destination table if it does not exist, delete rows in destination table first or append data and map columns (you may have different name for input and output) and and special transformation for specific columns (you script columns to do data validation or translation)

    Eventually you will see a screen that will ask if you want to run the package immediately, save the package and or schedule it. I always save the package first with a reasonable name. Once saved you can load it by expanding the Data Transformations Services folder and double clicking on the package name.

    VERY IMPORTANT - make sure you get the source and destination the right way round, DTS can transfer data BOTH ways.

    This is not complete but will get you started.

    BOL (Books Online) will give you more information.

    Experiment on a test server first so that you get use to it.

    Far away is close at hand in the images of elsewhere.
    Anon.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply