Post reply

Importing data from Informix into SQL Server 2000 using DTS

  • June 19, 2006 at 8:39 am

    #67493

    What is the process of bringing in data from an Informix table into SQL Server 2000 using DTS?  Is this process documented anywhere?  I am using Informix Client SDK (64 bit).

  • June 20, 2006 at 7:13 am

    #644799

    The basic Process for this woudl be to create a DTS task.  Create 2 connections, one usign you informix driver, the other with your SQL Server driver.  Then Highlight them both and rightclick and choose Data transformation task.  Either choose to copy a table or use a T-SQL statement to get the data you need from one to the other.  This is better documented in BOL.

    -Luke.

    PS. you could also use the wizard.

     

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • June 21, 2006 at 2:25 am

    #644955

    You can also link the Informix DBMS.  This may be the better option if you will be regularly importing data.  It allows you to query the Informix data directly from the Informix database using stored procedures and the openquery function.  The downside is that it is read only.

     

    Hope this helps

     

    Shaun

    Quis custodiet ipsos custodes.

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

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