sql server 2000 Dts and Ms access

  • I want to create DTS package for import data into sqlserver.

    --> Source is MS Access File which contain password protected.

    --> Destination is Sqlserver table.

    If i created Dts with odbc driver for source scheduling is not working.

    Can any body of help out of this.

  • Upgrade !!! SSIS in SQL2005 can handle this scenerio easily.

  • Can you provide more details on what the error is

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

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

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