Post reply

Import dBase tbl into SQLServer dynamically

  • May 15, 2003 at 5:29 am

    #106555

    Having the Tablename and location of a dBase file as Globals, how can I load it into a SQL Server database table having the same column mapping dynamically?

    Using the Transform Data Task object how do I set the transformation mapping dynamically ?

  • May 19, 2003 at 12:00 pm

    This was removed by the editor as SPAM

  • June 9, 2003 at 9:17 am

    #460391

    Use SQL server DTS package. It allows you to specify source, any transformations you may want to do and a destination table for the incoming data. Once you create your DTS package you can schedule it to run automatically . Checked out the online help for DTS packages.

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

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