• Ah, you will not get SSIS to read directly from the Paradox files. SSIS may be able to connect to a Paradox instance and read from it, but not directly from the files. You're going to have to spin up a Paradox install to host the files if you want any shot at reading them. These are database files so it's not as simple as just opening them up and viewing the data as text. Think about what it would look like if you attempted to open up a SQL Server data file? Even SSIS cannot read directly from the .mdf....the .mdf has to be hosted by a SQL Server DB engine. Same concept would apply for these Paradox files.

    That's really on the beginning also. If you can get these files up on a Paradox platform, you'll then need to create the matching table DDL in your SQL Server system and figure out how to move the data over and map the data types. For 52 Paradox databases, this is not a week's worth of work.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden