Post reply

recreate data table

  • June 9, 2004 at 5:24 pm

    #66015

    Hi friends
    I am using simple DTS package that imports data from foxpro table to sql server.
    everytime i run this package i want the table to be recreated in sql server database.
    i am wondering how to set that option in my dts package?
    any ideas please
    many Thanks

  • June 10, 2004 at 11:37 am

    #509939

    Add an Execute SQL task that includes a DROP TABLE command and have it execute before your data copy task. 

    If you're using a Data Transformation task, you can tell it to create the table before importing.  If you're using a task that doesn't offer the table create option, add a CREATE TABLE command to the Execute SQL task.

     

    Greg

    Greg

  • June 10, 2004 at 2:47 pm

    #509969

    Thats wonderful Greg

    finally i got it working.

    Thank u very much

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

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