Post reply

dts import

  • April 16, 2003 at 9:32 am

    #81422

    How to create a dts package to import a file regularly into a table.suppose I have the table A and I have file B,I wanted to import this file B into table A daily at 12:00 AM.How to aumate this process.

    Please let me know how to this.

    Thanks

  • April 16, 2003 at 9:38 am

    #454383

    You can do this with Tasks in DTS. Even you can import an EXCEL sheet as well. You just need to define what cell goes to which field.

    You can create a DTS packsge and right click and schedule the job. Thats all.

    .

  • April 16, 2003 at 1:15 pm

    #454421

    Do i need to execute it manually every day if i want to run it on everyday at 12pm.can u please help me in this.

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

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