Importing CSV files

  • Hi,

    I'm manually importing 3 CSV files to my database on daily basis using DTS, how can I make it automatic process?

    Thanks in advance...

    Regards,

    Jagadeesh

  • Hi you can schedule the dts packages or put them in a job. If the filenames are dynamic you have to write some active scripting (there are samples on this site)

  • Thanks Kaals...

    file names are static...I'll go with scheduling the dts package.

    Regards,

    Jagadeesh

  • Thanks Klaas...

    file names are static...I'll go with scheduling the dts package.

    Regards,

    Jagadeesh

  • Thanks Klaas...

    file names are static...I'll go with scheduling the dts package.

    Regards,

    Jagadeesh

Viewing 5 posts - 1 through 4 (of 4 total)

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